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 vote165 views1 answer
How to format tables in sqlplus
SQL
2 votes193 views3 answers
Sql delete duplicate
SQL
21 votes190 views4 answers
Oracle add column
SQL
0 vote196 views1 answer
Sql get year from datetime field
SQL
0 vote170 views2 answers
Update information in a mysql column
SQL
0 vote195 views2 answers
SQL FROM
SQL
0 vote193 views1 answer
Sqlserver now
SQL
1 vote224 views1 answer
Delete mysql ubuntu 20.04
SQL
0 vote170 views1 answer
Oracle tablespace autoextend
SQL
0 vote186 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL