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

-2 votes141 views1 answer
Modify column name in tsql
SQL
0 vote139 views1 answer
Mysql backup certain tables workbench
SQL
1 vote154 views1 answer
Postgresql datetrunc too slow
SQL
0 vote137 views1 answer
Mysql concatenate select results
SQL
26 votes375 views6 answers
Modify column name in sql
SQL
0 vote135 views1 answer
Mysql date format unix timestamp
SQL
7 votes139 views1 answer
Query postgres delete duplicates
SQL
0 vote138 views2 answers
T sql null or empty string
SQL
2 votes144 views1 answer
How to check grants on a package in oracle
SQL
16 votes151 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL