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 vote327 views2 answers
Sql left characters
SQL
1 vote329 views1 answer
Where to locate set password for mysql
SQL
0 vote308 views1 answer
Postgres select except
SQL
-1 vote307 views2 answers
On delete set default sql server
SQL
1 vote342 views1 answer
How to delay stored procedure execution in sql server
SQL
1 vote311 views2 answers
Postgresql backup and restore globals and data
SQL
3 votes355 views2 answers
Oracle sql first day of month
SQL
0 vote375 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote354 views1 answer
Add created and updatedAt fields in mysql
SQL
2 votes356 views3 answers
Mysql kill
SQL