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 vote137 views1 answer
WHERE not regex in SQL
SQL
3 votes156 views1 answer
Oracle detect invalid password
SQL
0 vote136 views2 answers
Nodejs mysql convert to plain object
SQL
1 vote123 views1 answer
Hackerrank sql test solutions
SQL
0 vote112 views5 answers
Sql table intermédiaire
SQL
4 votes123 views2 answers
How to delete row in sql
SQL
36 votes117 views3 answers
Finding duplicate column values in table with sql
SQL
4 votes129 views1 answer
Oracle user tables
SQL
0 vote121 views1 answer
Sql server get date of previous sunday
SQL
0 vote141 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL