Answers for "insert into select mysql"

myql insert from select

INSERT INTO table_name(column_list)
SELECT 
   select_list 
FROM 
   another_table
WHERE
   condition;

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'