Applications.ge

INSERT & SELECT

We can

SELECT

from one table and

INSERT

the selected data to another table using

INSERT & SELECT

statement

INSERT INTO `students` (`first_name`, `last_name`, `points`) 
SELECT first_name, last_name, points * 1.2 FROM students WHERE id = 3

The only thing we must consider is column positions (position must be the same)

by Valeri Tandilashvili

MySQL

INSERT & SELECT

MySQL Tutorial for Beginners

Pro tip: use ```triple backticks around text``` to write in code fences