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

1 vote202 views1 answer
How to print longest name in sql
SQL
4 votes339 views2 answers
Sql display today's date
SQL
0 vote219 views4 answers
Forenkey code alchemy sql
SQL
0 vote186 views1 answer
Hibernate xml property MySQL url, username and password
SQL
0 vote166 views1 answer
Create duplicate table postgres
SQL
0 vote275 views1 answer
Generate sql from specific migration ef core
SQL
0 vote223 views1 answer
Select top values sql
SQL
4 votes236 views1 answer
Rename stored procedure in sql server
SQL
1 vote207 views1 answer
Increase existing date in sql
SQL
0 vote186 views1 answer
Create boolean column in MySQL with false as default value?
SQL