Insert into select mysql

Insert select

INSERT INTO table2
SELECT * FROM table1
WHERE condition;

Insert into select mysql

INSERT INTO dealer_service_rate (username, groupname, rate) 
SELECT username, groupname, rate FROM sub_dealer_service_rate 
WHERE username='rohaannet'

Similar codes

0 vote191 views2 answers
How to install mssql on mac
SQL
0 vote181 views1 answer
Psql initialization
SQL
1 vote180 views1 answer
Create procedure with encryption
SQL
0 vote204 views2 answers
How to list all values of a column that start with a letter in sql
SQL
0 vote197 views1 answer
Snowflake drop column
SQL
1 vote213 views1 answer
Raw query must include primary key
SQL
0 vote132 views1 answer
Ms sql print more than 1 variable
SQL
1 vote209 views3 answers
Postgresql crete view
SQL
0 vote149 views0 answer
SQL
4 votes204 views2 answers
Tables in sql
SQL