insert value in sql from select query code example

Example 1: sql insert query

--sql insert quest example
INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

Example 2: sql insert into

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

Example 3: insert select

INSERT INTO table2
SELECT * FROM table1
WHERE condition;