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

0 vote105 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote189 views1 answer
Postgres dump sql insert
SQL
0 vote192 views1 answer
Show mysql account privilleges
SQL
0 vote178 views1 answer
Shortcut run sql pgadmin
SQL
0 vote135 views1 answer
Backup and restore of sqlite database from c# -sqlserver
SQL
2 votes148 views4 answers
Sql query interview questions
SQL
1 vote139 views1 answer
Replace all numbers in mysql
SQL
0 vote99 views1 answer
Mysql select top 2
SQL
1 vote138 views2 answers
Mysql join two tables
SQL
1 vote177 views1 answer
Ora-01950 no privileges on tablespace
SQL