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

0 vote133 views1 answer
Sql compound operators
SQL
0 vote147 views2 answers
Temp Space
SQL
0 vote141 views1 answer
Apex for oracle 11g
SQL
0 vote127 views1 answer
Mysql last 6 months
SQL
2 votes161 views3 answers
Sql server reseed identity column
SQL
0 vote154 views1 answer
Mysql regex select
SQL
0 vote147 views1 answer
Mysql get date diff in months
SQL
11 votes136 views1 answer
Get ddl materialized view oracle
SQL
21 votes152 views3 answers
Sql server search column name in all tables
SQL
1 vote131 views1 answer
Postgresql must appear in the group by clause or be used in an aggregate function
SQL