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

1 vote307 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
2 votes293 views1 answer
Mysql find tables with name
SQL
0 vote321 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote291 views1 answer
Jooq replace
SQL
1 vote301 views1 answer
Mysql month name extract
SQL
0 vote289 views1 answer
Sql select all tables from database change url
SQL
1 vote310 views1 answer
Mysql check string don't have number
SQL
13 votes335 views4 answers
Mysql remove foreign key constraint
SQL
0 vote286 views1 answer
Sum sqlserver
SQL
15 votes312 views7 answers
MYSQL
SQL