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 views2 answers
Cambiar nombre tabla mysql
SQL
0 vote155 views1 answer
How to close external sql connection in laravel
SQL
0 vote184 views1 answer
Sql check if field is not null
SQL
1 vote113 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote153 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote139 views1 answer
Assign value to var in SQL
SQL
0 vote152 views1 answer
Add super privilege mysql
SQL
0 vote132 views1 answer
Java spring boot connect to sql server
SQL
11 votes220 views1 answer
Oracle insert from select
SQL
3 votes141 views2 answers
Plsql print
SQL