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

4 votes189 views2 answers
Oracle last day of month
SQL
0 vote180 views1 answer
Mysql_error replacement
SQL
1 vote170 views2 answers
Populate sql table with random data
SQL
0 vote182 views1 answer
Group by two columns postgres
SQL
-2 votes202 views2 answers
Union all in sql
SQL
0 vote190 views1 answer
List all indexes postgres
SQL
1 vote207 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote178 views1 answer
Mysql query single row
SQL
16 votes180 views3 answers
MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote172 views1 answer
Show create table in postgresql
SQL