SQL Tutorial - 12: Inserting Data Into Tables Video Lecture | Microsoft SQL for Beginners - Database Management

hello guys welcome to my channel this is
the twelfth tutorial in this course and
in this tutorial we are going to
understand how we can insert data into
tables in SQL the insert query is used
to insert data in a table and using the
insert query you can add data into a
table one row at a time and there are a
couple of options that you have with
your insert query the first one is that
you specify the columns in which data is
to be stored and the other option is
that you do not specify the columns and
if you're doing this that is if you're
not specifying the columns in which you
know data is to be stored then you have
to make sure that the order in which you
put in the values in the insert query is
the same as the order in which you want
the values to be stored in the table
right and if this is you know seeming
complicated then don't worry we're going
to see the insert query in action in
just a minute and things will get clear
to you guys then and the syntax for the
first type is you mention the keyword
insert and then the keyword into then
the name of the table in which you want
the data to be inserted and then within
parentheses you specify the order of the
columns in which you want the values to
be inserted right so if you've got n
columns or if you want to put in your
data in n columns then you type in you
know column 1 column 2 column 3 up to n
columns and then you type in another
keyword values and then within another
set of parentheses you specify the
values that you want to be inserted in
the columns 1 to n right and the syntax
for the second option with the insert
query obviously as I said you do not
have to specify the columns in which you
want the values to be stored so you know
this is a little crisp you type in
insert then into and then the name of
the table and till this point the syntax
of this is pretty much the same as a
syntax this and you just don't specify
the columns within the parentheses and
then the rest of the part is also the
same so now we are going to insert data
in the employee table that we created
couple of tutorials ago
using the MySQL workbench so before we
insert data in the employee table let's
check out the structure of the employee
table so that we know what kind of
information we have to put in it right
and to do that I'll use the da SC
command and I'll type in employee
because that's the name of my table
press the ctrl enter combination and I
get the names of the four columns in the
employee table so the first one is ID
the second one is name third one is DOB
and the fourth one is email and ID and
ID is an integer field and name and
email both these fields are work
airfields and DOB is daytime field right
so now we know what kind of data we have
to put in this table so let me reduce
the size of this result set a little bit
if it's possible for me to do that well
yes I can do that and I'll type in the
keyword insert and we're going to check
out the first you know option syntax
first so insert into and then the name
of the table which is employee and then
within parentheses I'm going to specify
the columns in which I want the data to
be stored so the first one is ID the
second one is name the third one is DOB
and the fourth one is email right and on
the next line I'll type in the keyword
values and you know if you are putting
in numeric data in a field then you
don't have to put your data within
single quotes if you're putting
character data or do or date/time data
then you have to put that data within
single quotes right so since ID is a
numeric field I can just type in you
know some numbers so I'll type in one
nine zero one and then I'll type in my
name within single quotes and what the
hell just happened
so motherhood and I'm going to put
another comma and then I'll put in my
DOB and we discussed the format of the
date/time field that is the format in
which the date/time values are stored in
SQL you know when we discuss the
date/time data type
you know in the tutorial on date on data
types so the the format is you have to
first specify the year and that's one
nine eight nine and then you put in -
and specify the month which is 11 for me
and I was born in 20th November 1989 by
the way and I'll also specify the time
and to do that you have to put in a
space character and then the R's in the
24-hour format so I was born on 11:55
a.m. and I don't know the second so I'm
just going to put in 0 0 there and then
I also put in my email address which is
going to be within single quotes again
because it's a character field the email
field and module party are a trade of
hotmail.com
and that's it so I'll put in the closing
parenthesis at the end and the semicolon
to terminate the statement and when I
press the ctrl enter key combination I
get in the output section the green
check mark and I see that my statement
was processed successfully so if you
want to verify whether your statement
was a whether your insert statement was
executed successfully or not I'm just
giving you this information and we're
going to talk about the Select statement
in detail you know in a couple of
tutorials but you use the Select
statement and you put in the asterisk
symbol after the Select keyword and then
the keyword from and then the name of
the table from which you want to see
your rows right so I'm just telling you
this we're going to discuss this later
on and there you go you see in the
results set that in the ID field we have
1 9 0 1 as the entry in the name field
we have mother as the entry you have the
date of birth value and the email value
as well right so this is when you
specify the you know column set after
the insert into a table name thing and
you know you also specify the values
corresponding to each of the column that
is there in the table what if you do not
want to specify this and why would you
firstly not want to include this thing
in your insert into statement if suppose
your table consists of lots of columns
and you know you want to put values in
each column that you have in your table
right so in that case to insert data if
you want to insert 15 rows and you know
you would have to copy this part 15
times and you know you would also have
to type in 15 you know if it's got 20
columns if your tables got 20 columns
and you have to type in 20 column names
within the parentheses right and that
can be pretty boring and pretty
time-consuming so in order to avoid that
you can just type in insert and then
into and you know the name of the table
which is employee and you know you don't
have to put in the column set in the
parenthesis and you can directly type in
the keyword values and then you know
just type in some values so 2,000 and
the name could be ABC and the date of
birth could be 2 0 1 3 and 1 10 and 0 8
and then I can you know also type in
some time value like 12 54 and 11 right
and I can type in some value for the
email address field - like ABC ABC at
the raid of gmail.com you put the
semicolon at the end to terminate the
statement when I press the ctrl enter
key combination now again I see that the
insert into statement was processed
successfully and I would use the Select
star thing again to see if my tables got
the data that I just put in it employee
and there you go now you see that the
table has two rows the first row is as a
result of the first and sergeant
into statement that we executed in the
second row is a result of the second one
that we executed so a couple of things
that you have to keep in mind if you're
using if you if you're fond of the
second you know
option of insert into the the things
that you have to keep in mind are that
if you're using this then the order in
which you specify the data you know in
the value set that is within the
parentheses after the values keyword it
has to be the same as the order in which
the fees exist in the table right and
that order you can figure out by
executing the describe command right so
if in case the order is different then
you can get a type mismatch error or you
know it could happen that the email
address is stored in the name field and
the name is stored in the email address
field or the date/time is stored in some
you know other field so that kind of
thing can happen in order to avoid that
I would suggest you to you know keep
your tables short so if you want to put
fifteen columns in your table then you
know try to somehow figure out ways in
which you can split you know the the
fifteen columns into three tables like
you know have three table instead of one
and you keep five columns in one table
five mother and five mother so you know
that's going to help you organize your
data in a better way and also while
inserting data into the tables it will
be easy for you right so thank you so
much for watching this tutorial I'm
going to see you guys in the next one in
which we'll discuss something
interesting and important for sure and
please subscribe to my channel in case
you have already and I'm going to see
you soon