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 votes265 views2 answers
Where clause in sql
SQL
12 votes272 views5 answers
Sql merge
SQL
0 vote262 views1 answer
Soql more than today
SQL
13 votes276 views1 answer
Sql join 3 tables on id
SQL
0 vote266 views1 answer
Example of sql querry result sepapreted by comma
SQL
3 votes269 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote265 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote260 views1 answer
On update current_timestamp jpa
SQL
7 votes297 views6 answers
Mysql group concat
SQL
9 votes299 views3 answers
Where clause sql
SQL