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 votes226 views1 answer
Sql update alias
SQL
1 vote221 views2 answers
Mysql join two tables
SQL
0 vote233 views1 answer
SQL FROM-Klausel
SQL
0 vote216 views1 answer
Power query datetime to date
SQL
0 vote256 views2 answers
Postgresql variable in query
SQL
0 vote224 views1 answer
Inner join distinct
SQL
3 votes220 views1 answer
Sql set null
SQL
5 votes252 views4 answers
SQL Order of execution
SQL
26 votes217 views2 answers
What is the sql statement that finds duplicate usernames
SQL
0 vote316 views2 answers
Sqlalchemy default value for column
SQL