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 vote184 views1 answer
Select other columns with distinct
SQL
1 vote188 views1 answer
Oracle case
SQL
0 vote203 views1 answer
Oracle string length
SQL
3 votes183 views2 answers
Sql end of month
SQL
0 vote223 views1 answer
Sql remove decimal places
SQL
1 vote205 views1 answer
Apex select list ORA-20999
SQL
1 vote190 views1 answer
Mysql f# examples
SQL
2 votes202 views1 answer
Mysql cannot delete or update a parent row
SQL
1 vote191 views1 answer
Find a column in all tables postgres
SQL
0 vote204 views4 answers
Forenkey code alchemy sql
SQL