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

25 votes428 views4 answers
Import mysql dump command line
SQL
0 vote330 views1 answer
Remove from table where
SQL
1 vote343 views1 answer
Adding a check statement in sql
SQL
1 vote363 views1 answer
Find a column in all tables postgres
SQL
0 vote381 views1 answer
Change permission to database mysql
SQL
1 vote354 views1 answer
Sql not equal multiple columns
SQL
-1 vote360 views2 answers
Create temporary table sql
SQL
0 vote338 views2 answers
Change database postgres
SQL
0 vote353 views1 answer
Less than date query sqlachemy
SQL
0 vote326 views1 answer
Python mysql query where
SQL