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

14 votes362 views1 answer
Sql value of string
SQL
0 vote353 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
4 votes351 views2 answers
Show all database inside postgresql
SQL
1 vote356 views1 answer
Postgres check for foreign key
SQL
1 vote395 views1 answer
Postgres left join
SQL
0 vote387 views1 answer
Mysql dump with table query
SQL
0 vote351 views1 answer
Sql bild in function
SQL
0 vote416 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote343 views1 answer
How to save data in database in mysql node
SQL
0 vote319 views7 answers
10 random questions use python and SQL
SQL