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 vote205 views2 answers
CREATE OR REPLACE FUNCTION
SQL
4 votes196 views3 answers
Mysql get column names from table
SQL
2 votes176 views1 answer
Mysql application.properties spring boot
SQL
9 votes223 views6 answers
Replace sql
SQL
1 vote178 views3 answers
How to truncate table with foreign key constraint
SQL
0 vote184 views1 answer
Sql server phone constraint
SQL
0 vote177 views1 answer
Postgresql check total storage
SQL
0 vote180 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
3 votes128 views1 answer
V$session not found in oracle
SQL
0 vote123 views1 answer
Oracle list all stored procedures
SQL