Try the Introductory SQL Course for Free!

The INSERT Statement in SQL- Tutorial and Video

/ / Latest, SQL

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: A picture of the video lesson on the INSERT statement in SQL.

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.

MySQL 5.7:

https://dev.mysql.com/doc/refman/5.7/en/insert.html

SQL Server 2012:

https://technet.microsoft.com/en-us/library/ms174335.aspx

Access 2013:

https://msdn.microsoft.com/en-us/library/office/ff834799.aspx

TOP
SALE! $49 All-Access 0 Days 9 Hours 44 Minutes 19 Seconds      $199 $49 Entire Library!
See Deal