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

3 votes100 views1 answer
Insert into table from another table mysql
SQL
0 vote95 views1 answer
Get records in sql according to month name and count
SQL
3 votes116 views2 answers
How to force truncate a table in mysql
SQL
1 vote111 views1 answer
Sqlserver create table from select
SQL
7 votes101 views2 answers
Phpmyadmin change password
SQL
0 vote129 views1 answer
Postgres full text search example
SQL
4 votes106 views4 answers
Start mysql
SQL
0 vote112 views1 answer
Example of sql querry result sepapreted by comma
SQL
1 vote113 views1 answer
How to use db.execute
SQL
0 vote99 views1 answer
Tsql default value when no value returned by query
SQL