0:02
[Music]
0:11
hello friends welcome back to our
0:13
channel so in the previous session we
0:15
have seen the
0:17
creation command create command so that
0:19
is a ddl command and how to create a
0:22
database how to create the tables so we
0:25
have seen in the previous session and
0:26
now we have so we will see one more
0:28
command that is a insert command
0:31
so
0:37
insert command okay so insert command is
0:39
a dml command that a manipulation
0:41
language okay so this comes under
0:46
dmn command
0:49
so this
0:50
insert method or insert command is used
0:53
to
0:57
insert
0:59
data
1:01
into
1:03
tables
1:04
so already we have seen how to create a
1:06
table in the previous session so after
1:07
creating the table we have to insert the
1:09
values so here while inserting while
1:12
creating a table we have we have derived
1:15
the attributes with the corresponding
1:17
data types
1:19
so here we have to pass the values for
1:22
all the attributes or a limited
1:25
attributes
1:27
so we'll see the syntax for all the
1:28
three all the things so how can we
1:30
insert
1:31
a single row
1:33
for all the attributes and how can we
1:36
insert a single row with a limited
1:38
number of attributes and how can we
1:40
insert a multiple rows okay with more
1:43
number of attributes with all the
1:45
attribute values and how can we insert
1:47
uh multiple rows with a limited number
1:49
of attributes right so first one
1:54
so let us see the syntax so sql is a
1:57
prompt okay after the prompt
1:59
use a command called
2:01
insert
2:04
into
2:06
table name
2:10
table name
2:13
okay and here you need to give
2:18
attribute
2:19
one
2:23
attribute
2:24
2 and so on
2:27
and so on
2:31
values
2:34
the value for first attribute
2:37
see
2:39
attribute one underscore a value so the
2:43
value
2:44
corresponds to this particular attribute
2:45
one
2:46
similarly
2:50
attribute to
2:52
value
2:54
and so on
2:56
so this is a command
2:58
which we will use to insert
3:00
a single row
3:02
with with a specific attributes that
3:04
means see for example
3:07
so we have created a student table in
3:08
the previous session with the four
3:10
attributes
3:12
four attributes that is
3:14
student id
3:16
student name
3:18
student branch
3:21
student percentage
3:22
so here we need to give the
3:25
data for
3:27
all the values i mean all the attributes
3:30
okay
3:30
see
3:32
so s id student id
3:36
student name
3:40
student branch
3:44
student percentage so these are the
3:48
four
3:48
fields or four attributes we have
3:50
created so one thing you just remember
3:53
if the data type
3:55
if the data type
3:57
is of a string
3:58
is of a string
4:00
so the value should be enclosed in
4:03
quotations the value should be enclosed
4:05
in quotation that means if any of the
4:08
attributes is derived with a string data
4:11
type that means either a character or a
4:12
marker or a text so that should be
4:15
enclosed in single quotations so that
4:17
you have to remember so where we have
4:19
going to value so we are giving the
4:21
value here itself so
4:24
so here we have not given any
4:26
constraints while creating a table
4:27
because we have not discussed about the
4:29
constraints so far so in the further
4:30
sessions we will discuss about the
4:31
constraints and again we will uh
4:34
see the insert command so
4:36
we we can give
4:38
a partial values that means a partial
4:41
attributes values for partial attributes
4:43
not for all the attributes that means if
4:45
you want to give you can give the values
4:46
for only these three you can skip this
4:48
one
4:50
or you can give the complete values that
4:52
means the values for all the four
4:54
attributes
4:55
right so this is the syntax
4:57
okay this is the syntax to insert the
4:59
values
5:00
for
5:02
okay limited attributes not for all the
5:04
attributes so you can also give the all
5:06
the attribute values okay
5:08
but if you want to give only a few
5:11
values for only a few attributes you
5:13
have to mention the attribute names and
5:15
attribute values
5:18
see
5:19
example
5:21
i need to give this one so
5:23
sql
5:25
insert
5:27
into
5:29
student
5:30
so what we have done we have to mention
5:32
the attribute so s id
5:35
yes name i just want to pass only this
5:38
one
5:38
so values
5:40
values
5:41
one zero one and
5:43
sandi
5:45
so this is the thing
5:46
i have executed so sandhip is a bearcat
5:49
so with how to enclosing quotations
5:52
single quotation so after executing this
5:54
one we will get one zero one
5:56
sandi
5:57
and all these values will be null by
6:00
default it will be none okay by default
6:02
it will be a null without using any
6:04
constraint okay without using any
6:06
constraint the default value will be
6:07
null so we have not passed any value for
6:11
these two attributes branch and
6:12
percentage so they will be filled with
6:13
the null
6:14
so if you want to fill all the four
6:17
values so you need not mention this one
6:20
you need not mention this one insert
6:22
into table name values give the value
6:25
for all the attributes in the table that
6:27
means insert into student
6:30
insert into student
6:32
okay
6:34
values
6:36
values
6:37
so one zero two
6:41
some saradi
6:43
some cac
6:46
95 so
6:49
here you can see the table consists of
6:51
four attributes and we are giving all
6:53
the four values here
6:55
okay we will not get any error so if you
6:57
are
6:58
want to give only the three values with
7:00
this syntax this will return an error
7:03
because the student is having a four
7:06
columns or four attributes but we are
7:07
passing only the three values
7:09
so if you don't want to get this type of
7:11
error you have to mention the attribute
7:14
names here so for which we are passing
7:16
the values okay if you are not
7:18
specifying any attribute names here so
7:20
you need to pass the value for all the
7:23
attributes so 95
7:25
so this will enter the values one zero
7:27
two
7:31
and branch cse
7:33
and percentage 95
7:35
so this is the syntax to insert
7:38
the elements all the elements
7:41
into a table okay all the values for all
7:44
the attributes
7:46
and what's the syntax for inserting a
7:48
multiple rows multiple rows at a time so
7:52
this will insert only one row at a time
7:54
so how to insert a multiple rows at a
7:56
time so simply you can see this one and
8:00
again
8:01
without executing the query without
8:03
terminating the query use a comma and
8:06
again give the second row add values
8:09
attribute one
8:10
value
8:16
attribute 2
8:17
value
8:19
and so on
8:21
okay
8:21
and comma use a third one
8:25
so that implies the two rows will be
8:27
inserted into the table so let us see
8:30
instead of terminating this query
8:33
comma
8:34
so let us change this one one zero three
8:52
five
9:04
that implies we are inserting three rows
9:08
into a table with a one insert command
9:11
okay we are passing three we are trying
9:13
to insert three rows at a time so all
9:16
the three rows will be inserted into
9:17
this table
9:20
okay
9:21
only one thing if you want to give the
9:23
values for all the attributes you need
9:25
not mention the attribute names here and
9:27
if you want to insert the values for a
9:29
specific attributes you have to mention
9:31
the attribute names for which we are
9:34
giving the values so if it is a single
9:37
row insertion or a multiple rows
9:39
insertion whatever it may be
9:42
right so hope you understood this inside
9:43
comment so don't worry so i'll execute
9:45
each and every concept each and every
9:49
case that means how to insert
9:52
specific attributes and how to insert
9:54
the values for all the attributes single
9:56
row insertion multiple rows in such and
9:58
everything i will execute in the mysql
10:01
so let's stop here so let us move on to
10:03
the mysql
10:07
hello friends so
10:09
just now we have seen the syntax for
10:11
inserting the data into a table
10:13
so now we will see the implementation of
10:16
that insert command so first let us open
10:19
the mysql in a command line
10:21
so give the password
10:24
so first let us clear the screen
10:27
system cls
10:29
now let us use the database
10:32
youtube because in the previous session
10:34
we have already created a database let
10:36
us check for that
10:39
databases and here you can see
10:42
there is a database called youtube so
10:44
let us use that youtube and enter into
10:46
that particular youtube database
10:48
so use youtube now
10:50
let us check with the tables which are
10:52
available in that particular thing so
10:55
show tables
10:56
so student table is there so now
10:59
uh we'll check whether the data is
11:01
available in the student or not so here
11:03
the syntax is select a star from
11:08
student so that it will display all the
11:10
records so it is an empty set but that
11:12
means
11:13
the that's an empty table that means
11:14
there are no records available in the
11:16
story table now we will insert this
11:19
data into the student so before
11:21
insertion we have to know what are the
11:23
attributes that are available in that
11:25
particular student table so in order to
11:27
know the complete structure of that
11:28
student table we have to go with the
11:30
desc describe
11:32
student
11:35
so there are four attributes one is a
11:37
student id which is of integer a student
11:39
name which is of where care student
11:41
branch which is of web care and student
11:43
percentage which is a float and here we
11:45
have not given any constraint
11:48
any constraint okay so we'll discuss
11:50
about these constraints after this one
11:52
because
11:53
in the next session after completion of
11:55
the constraints
11:56
we will check all the constraints by
11:59
using this insertion command so before
12:01
that we have to know about the syntax of
12:04
insertion so let us insert the data into
12:07
this particular table
12:08
right so for that syntax insert
12:12
into table name that is the student
12:15
okay and give the attribute names so if
12:17
you want to give the values for only a
12:20
limited attributes you have to give the
12:22
attribute names so if i want to give
12:25
only the
12:26
three values that means the student id
12:28
okay std id comma
12:31
std
12:32
name comma
12:34
std
12:36
branch okay i just want to enter the
12:39
values for these three attributes only
12:42
so
12:43
values
12:45
give the values here one zero one
12:47
student id student name so if it is a
12:50
where care or a character or a text data
12:52
type the data should be given in
12:54
quotations itself so give the quotations
12:57
so i'll give sandeep
12:59
comma
13:01
and we have to give the branch so i'll
13:03
give the branch
13:04
cse right
13:07
so you can see
13:08
query okay one row affected that means
13:10
already the data has been inserted into
13:12
that particular table so let us check so
13:14
in order to get the details go with the
13:16
query select star
13:18
from table name so you'll get one record
13:22
so we have not given any value for the
13:23
student percentage so by default it will
13:25
be null because the default is null we
13:28
have not given any constraint if you
13:30
have given any constraint that
13:31
particular value will be done okay so
13:33
we'll discuss about these constraints in
13:35
the next session so if you are not
13:37
giving any value here it will take a
13:39
default value
13:41
right next
13:43
next
13:44
if you want to give the complete values
13:47
if you want to give the complete value
13:49
that means all the four attributes the
13:50
values for all the four attributes you
13:52
need not
13:53
give the
13:54
attribute names here insert into
13:56
student and here you need not give the
13:59
attribute names directly student into
14:01
student
14:02
values so here you need to give one zero
14:05
to
14:07
sahara the
14:10
csc
14:11
so it's a that catc
14:15
some 99
14:17
so now
14:18
see query okay one row affected
14:20
also
14:22
we got
14:23
the data has been inserted into table we
14:26
can select here student see two tables
14:28
have been selected
14:30
and if you are trying to give this one
14:33
without one attribute
14:34
see
14:35
here i'll give
14:37
one zero three
14:42
ramu
14:44
easy and i just want i don't want to
14:46
give the percentage
14:48
so you will get an error because
14:51
here we are not giving any column names
14:54
here we are not giving any column names
14:56
so if you are not giving any columns
14:58
names you have to pass the values for
15:00
all the columns here we are having four
15:03
columns so if you are not specifying the
15:05
column names so we have to specify all
15:08
the four values for these four columns
15:10
so if you want to give only the three
15:12
values here you have to mention three
15:14
columns in this way
15:16
so here you can see we have given only
15:18
three columns
15:21
right
15:21
then
15:22
how what is the procedure to give a
15:25
multiple values
15:26
so let us check
15:27
so select
15:29
sorry
15:30
insert
15:32
into student
15:35
okay values
15:37
here pass on the values so 103
15:44
ramu
15:46
ece
15:49
96 okay
15:52
and comma
15:54
give one more value so one zero four
15:58
some suresh
16:02
triple
16:05
93
16:07
[Music]
16:10
right
16:12
if you want to give a one more value
16:15
use a comma
16:16
give one more value
16:21
105
16:23
comma
16:25
hurry
16:27
make
16:29
92
16:31
use the semicolon execute so you can
16:33
observe here query okay three rows has
16:37
been affected that means all the three
16:39
rows have been
16:41
inserted so you can select here so
16:43
select star from
16:45
student
16:47
so you can see one zero three one zero
16:49
one zero five
16:50
so all the three columns has been i mean
16:52
all the three rows has been inserted so
16:54
if you want to give this single row if
16:56
you want to insert the single row so
16:58
this is syntax and two two types so that
17:01
means if you want to give a same value
17:04
or if you want to give i mean all the
17:06
values are if you want to specify a
17:08
limited number of attributes values for
17:10
limited number of attributes and if you
17:12
want to give a multiple rows simply use
17:14
the com use the command insert and
17:18
give the details of complete row in a
17:21
tuple right in one parenthesis so you
17:23
can do a multiple values in the same
17:26
statement in the same query so if you
17:29
want to give the multiple
17:31
values for the limited attributes here
17:33
you need to specify the attributes
17:36
so this is how we can insert the values
17:39
into a table
17:42
right so hope you understood this insert
17:45
command
17:46
so insert command is used to insert the
17:48
data into the table so for that we have
17:51
to know what are the attributes and what
17:53
are the
17:54
data types for the corresponding
17:56
attributes and if it if the attribute
17:59
data type is
18:00
is character or the arcade or a text
18:04
right if it is a string data type simply
18:07
we have to specify it in a quotations
18:10
so just remember these things
18:13
right so hope you understood and let's
18:15
stop here so if you are having any
18:17
doubts regarding this insert method so
18:19
feel free to post your notes in the
18:20
comment section definitely i will try to
18:22
clarify all your doubts if you realize
18:24
my session like my session share my
18:26
session with your friends and don't
18:27
forget to subscribe to our channel
18:29
thanks for watching thank you very much