how to insert data into table using select query in mysql code example
Example: myql insert from select
INSERT INTO table_name(column_list)
SELECT
select_list
FROM
another_table
WHERE
condition;
INSERT INTO table_name(column_list)
SELECT
select_list
FROM
another_table
WHERE
condition;