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

1 vote121 views1 answer
Influxdb export to csv
SQL
0 vote130 views2 answers
Sql having multiple conditions
SQL
3 votes116 views1 answer
Postgres update column with value from another table
SQL
3 votes165 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
-2 votes182 views1 answer
Trunc in sql
SQL
0 vote137 views1 answer
Mysql show create db
SQL
1 vote122 views1 answer
Ilike for date postgres
SQL
0 vote136 views1 answer
Como hacer una consulta en sql
SQL
0 vote123 views1 answer
Ms Sql set us timezone
SQL
0 vote117 views1 answer
Get records in sql according to month name and count
SQL