Categories
MySQL

In SQL, insert data into another table, insert into select

SQL also throwing data from a table into another table. Add the data in the table to another table in SQL. With MySQL or phpMyAdmin, you can insert the data in the table into another table in SQL, insert into select.

INSERT INTO data-to-move-table (field1, field2, field3)
SELECT field-name-1, field-name-2, field-name-3
FROM data-moved-table
WHERE AGE> = 25