The INSERT Statement in SQL- Tutorial and Video
The Insert Statement in SQL: Video Lesson
This video lesson, titled “The INSERT Statement,” shows how to use the INSERT statement in SQL. This video lesson comes from our complete Introductory SQL training, titled “Mastering Introductory SQL Made Easy v.1.0.”
The Insert Statement in SQL: Overview
After examining the core SQL statements used to create objects within relational database management systems, you should next learn how to add, edit, delete and select data within these same systems. SQL uses the Data Manipulation Language statements to accomplish these tasks. The first statement to learn is the INSERT statement. This statement is used to insert new records into a table. Note that this is NOT the command used to update information within existing table records. That task is accomplished by the UPDATE statement IN SQL.
The core SQL of the INSERT statement used to create new records within a table is shown below. The “table_name” parameter is the name of the table within which the records are to be created, “field_name” is the name of the field within which to place the data, and “value” is the value of the data to place into the field.
INSERT INTO table_name (field_name, field_name1, field_name2, etc.)
VALUES (value, value1, value2, etc.)
Note that it is possible to omit the “field_name” parameters within some implementations of the INSERT statement in some relational database management systems. Also, you will not need to specify a value within this statement for any fields that are assigned an auto-incrementing field value. You may also skip entering the names of field_name parameters into which you would like to enter NULL values, if those fields can accept the entry of a NULL value and you have no actual data to enter into those fields.
The INSERT Statement in SQL- Tutorial and Video: A picture of the video for “The INSERT Statement” within the “Mastering Introductory SQL Made Easy v.1.0” training interface.
You can view the specific implementations of the INSERT statement within MySQL 5.7, SQL Server 2012, and Access 2013 by clicking the following hyperlinks.
SQL Server 2012: