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 vote281 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
5 votes267 views2 answers
Copy data from one database to another
SQL
1 vote287 views1 answer
Oracle datafile max size 32gb
SQL
0 vote301 views1 answer
Doctors appointment
SQL
0 vote280 views1 answer
If column value is null then in mysql
SQL
1 vote275 views1 answer
Sql avg group by
SQL
0 vote303 views1 answer
Acutal month year
SQL
0 vote280 views1 answer
Create schema sql server
SQL
0 vote340 views1 answer
Reindexing all tables sql server
SQL
0 vote271 views1 answer
Sqlite3 pragma foreign keys
SQL