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 vote113 views1 answer
Call function sql oracle with output put line
SQL
0 vote144 views1 answer
How to add auto increment primary key
SQL
0 vote111 views1 answer
Safe mysql
SQL
0 vote72 views1 answer
How to set field to null in sql
SQL
2 votes108 views1 answer
SQLSTATE[HY000] [1049] Unknown database
SQL
23 votes124 views1 answer
How remove column in mysql
SQL
1 vote105 views1 answer
How to delete a record from sqlite in android
SQL
0 vote113 views1 answer
Mysql change innodb to myisam
SQL
11 votes118 views2 answers
Import sql file laravel cmd
SQL
0 vote124 views2 answers
Sql query in dax power bi
SQL