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

3 votes144 views4 answers
Mysql decimal
SQL
1 vote130 views4 answers
Sql now
SQL
0 vote152 views1 answer
Ksql quickstart docker
SQL
0 vote174 views1 answer
Many rows to 1 string mysql
SQL
1 vote140 views2 answers
Sql server backup table
SQL
0 vote157 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote143 views1 answer
SQL SELECT-Klausel
SQL
0 vote157 views1 answer
Postgresql array to rows
SQL
0 vote150 views1 answer
Update one column from another column in same table
SQL
1 vote144 views2 answers
Sql server add time to date
SQL