SQL INSERT INTO Statement
The INSERT INTO statement is used to insert new rows into a table. VALUES (value1, value2,....) You can also specify the columns for which you want to insert data: VALUES (value1, value2,....) This "Persons" table: LastName FirstName Address City Pettersen Kari Storgt 20 Stavanger And this SQL statement: Will give this result: LastName FirstName Address City Pettersen Kari Storgt 20 Stavanger Hetland Camilla Hagabakka 24 Sandnes This "Persons" table: LastName FirstName Address City Pettersen Kari Storgt 20 Stavanger Hetland Camilla Hagabakka 24 Sandnes And This SQL statement: Will give this result: LastName FirstName Address City Pettersen Kari Storgt 20 Stavanger Hetland Camilla Hagabakka 24 Sandnes Rasmussen Storgt 67 The INSERT INTO Statement
Syntax
INSERT INTO table_name
INSERT INTO table_name (column1, column2,...)
Insert a New Row
INSERT INTO Persons
VALUES ('Hetland', 'Camilla', 'Hagabakka 24', 'Sandnes')
Insert Data in Specified Columns
INSERT INTO Persons (LastName, Address)
VALUES ('Rasmussen', 'Storgt 67')