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 vote128 views1 answer
Get the next column of a table in mysql
SQL
0 vote101 views1 answer
Create api project in visual studio 2019 and sql server
SQL
7 votes111 views2 answers
Add column table pl sql
SQL
0 vote107 views1 answer
Postgresql CREATE EXTENSION pgcrypto
SQL
0 vote137 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
4 votes201 views1 answer
What are the data types
SQL
4 votes112 views2 answers
Mysql delete user if exists
SQL
0 vote127 views1 answer
Mysql type for large numbers with many decimal
SQL
5 votes173 views1 answer
Oracle source query
SQL
2 votes116 views3 answers
How to pass password mysql command line
SQL