Sql insert values into table

This article is tagged with: Sql insert values into table and mysql

sql insert query

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

sql insert into statement

SQL INSERT STATEMENT

sql insert into

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

sql insert values into table

INSERT INTO table2 (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM table1
WHERE condition;

sql insert values into table

INSERT INTO table2
SELECT * FROM table1
WHERE condition;

This article is tagged with: Sql insert values into table and mysql