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

16 votes190 views4 answers
Mysql import from sql file
SQL
1 vote275 views1 answer
Sql server read uncommitted
SQL
0 vote173 views1 answer
Check if table exists oracle
SQL
1 vote190 views1 answer
Sql exclude duplicates and find even id
SQL
0 vote186 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote193 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
2 votes178 views1 answer
Mysql query unique column
SQL
1 vote187 views1 answer
Sqlalchemy order_by
SQL
0 vote188 views1 answer
How to print records of employees hired in particular month in oracle
SQL
1 vote192 views1 answer
Search for tables with name postgresql
SQL