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 votes222 views3 answers
Raw select laravel
SQL
0 vote195 views1 answer
How to reset the database value in SQL server
SQL
0 vote186 views1 answer
Sql server whoami
SQL
7 votes195 views2 answers
Show size database mysql
SQL
0 vote215 views1 answer
See the structure of a table mysql
SQL
0 vote189 views1 answer
Install mysql for fedora 34
SQL
56 votes355 views5 answers
Psql create user
SQL
5 votes158 views1 answer
Postgres upsert
SQL
0 vote193 views1 answer
Mysql root localhost run
SQL
0 vote208 views1 answer
Report in database
SQL