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 vote308 views1 answer
Multiple row join
SQL
0 vote158 views1 answer
Postgres list tables and row counts
SQL
5 votes155 views2 answers
Mysql drop table cascade
SQL
0 vote176 views1 answer
Select new table sql
SQL
0 vote164 views1 answer
Soql user profile
SQL
8 votes143 views1 answer
Oracle add month
SQL
1 vote172 views1 answer
Delete dublicate rows sql
SQL
0 vote154 views1 answer
Sql select maximum column with other columns returned
SQL
1 vote207 views3 answers
Date_add mysql
SQL
0 vote182 views1 answer
Create function in microsoft sql server
SQL