MySQL Insert

SQL INSERT statement allows you to insert one or more records into a database table. In addition SQL INSERT statement also allows you to copy data from another database tables to a database table.

Here is the syntax of SQL INSERT statement which allows to insert one record at a time into a database table:
1
2
3
4
5
6
7
8
9
10
11
12
13
INSERT INTO table_name (column1, column2…)
 
VALUES (value1, value2,…)
 
SQL INSERT statement also allows to insert multiple records into a database table at a time. Here is the syntax:
 
INSERT INTO table_name(column1,column2…)
 
VALUES (value1,value2,…),
 
(value1,value2,…),
 
…
SQL INSERT statement in addition allows to copy data from another database tables to a database table. Here is the syntax:
1
2
3
4
5
6
7
INSERT INTO table_name(column1, column2,…)
 
SELECT value1, value2…
 
FROM table_name2
 
…
MySQL Connect
MySQL Create
MySQL Select
MySQL Where