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 vote371 views1 answer
Mssql find deadlocks
SQL
0 vote326 views1 answer
Mysql multiple primary keys
SQL
23 votes314 views3 answers
Mysqldump
SQL
0 vote328 views1 answer
No query unable to fetch row sqlite
SQL
1 vote326 views3 answers
How to truncate table with foreign key constraint
SQL
12 votes344 views4 answers
How to check mysql version ubuntu
SQL
1 vote335 views1 answer
Mysql return if it contains
SQL
0 vote349 views2 answers
Mysql show foreign keys
SQL
1 vote305 views1 answer
Ilike for date postgres
SQL
0 vote312 views1 answer
Is not sql
SQL