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

2 votes151 views1 answer
Enum in SQL Server
SQL
5 votes167 views1 answer
Oracle list functions
SQL
0 vote162 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote171 views1 answer
Create table like sql
SQL
0 vote149 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote151 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote154 views1 answer
Linked server delete openquery
SQL
0 vote177 views1 answer
Flask sqlalchemy session delete
SQL
0 vote178 views1 answer
Sintaxis SELECT sql
SQL
0 vote144 views1 answer
T-SQL MERGE with condition what is not matched?
SQL