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 votes284 views1 answer
Where clause for child record apex
SQL
0 vote250 views1 answer
Oracle select invalid views
SQL
0 vote261 views1 answer
Laravel eloquent get generated sql
SQL
2 votes270 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
1 vote289 views3 answers
How to pass password to mysql command line
SQL
0 vote254 views1 answer
Sql select most frequent value in group
SQL
1 vote259 views1 answer
Create table variable in sql stored procedure
SQL
0 vote349 views1 answer
Delet all record statment sql
SQL
0 vote271 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote258 views1 answer
Kill thread
SQL