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

2 votes355 views1 answer
Sql percentage with % rounded down
SQL
3 votes397 views1 answer
Apex call duration
SQL
0 vote321 views1 answer
Describe in sqlite3
SQL
38 votes332 views4 answers
Count sql
SQL
6 votes357 views3 answers
Mysql remove user privileges
SQL
0 vote332 views1 answer
Oracle temporary table
SQL
0 vote339 views1 answer
Group by two columns postgres
SQL
2 votes332 views1 answer
Set column to not null mysql
SQL
0 vote334 views1 answer
Postgresql combine values in one field
SQL
0 vote337 views1 answer
How to take sum of column with same id and different table in SQL?
SQL