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

8 votes330 views1 answer
Oracle search source code
SQL
12 votes344 views2 answers
Find duplicates mysql column
SQL
0 vote334 views1 answer
How to find columns with null values in sql
SQL
0 vote334 views1 answer
Create or replace view postgress
SQL
0 vote324 views1 answer
Sql cross apply vs join
SQL
0 vote326 views1 answer
Install mysql 8 linux
SQL
0 vote332 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote340 views1 answer
How to access to mysql without root
SQL
1 vote384 views1 answer
Postgresql if 0 then 1
SQL
1 vote335 views2 answers
Mysql filter by date mount
SQL