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

6 votes272 views2 answers
Return columns from table sql
SQL
1 vote296 views1 answer
Rows to comma separated values in mssql
SQL
0 vote287 views1 answer
SQL loop with cursor
SQL
4 votes244 views2 answers
Access to dialectresolutioninfo cannot be null when 'hibernate.dialect' not set
SQL
0 vote306 views1 answer
Oracle tablespace autoextend
SQL
1 vote288 views1 answer
Select not matching data with join table
SQL
0 vote259 views1 answer
Sql requete number pair
SQL
26 votes292 views2 answers
Mysql workbench download
SQL
0 vote271 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote294 views1 answer
Kill a pid redshift
SQL