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 votes292 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
3 votes270 views1 answer
Oracle nextval
SQL
0 vote279 views1 answer
Sql query to delete row by id
SQL
0 vote281 views1 answer
Sql server convert date to weekday
SQL
5 votes285 views1 answer
Oracle create table comment
SQL
0 vote276 views1 answer
The local psql command could not be located
SQL
0 vote302 views1 answer
Login failed for user sql server
SQL
0 vote299 views1 answer
Flexible search query delete table
SQL
1 vote277 views1 answer
Return size of tables in mysql
SQL
0 vote276 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL