Software Development Exam > Software Development Videos > PHP for beginners > MySQL Inserting Data
MySQL Inserting Data Video Lecture | PHP for beginners - Software Development
|
30 videos
|
FAQs on MySQL Inserting Data Video Lecture - PHP for beginners - Software Development
| 1. What is MySQL? |  |
Ans. MySQL is an open-source relational database management system (RDBMS) that allows users to store, manage, and retrieve data efficiently. It is widely used in web applications and is known for its scalability, reliability, and ease of use.
| 2. How can I insert data into a MySQL database? | |
Ans. To insert data into a MySQL database, you can use the INSERT INTO statement. Here is an example of the syntax:
INSERT INTO table_name (column1, column2, column3)
VALUES (value1, value2, value3);
In this example, "table_name" refers to the name of the table you want to insert data into, and "column1, column2, column3" represent the names of the columns you want to insert data into. "value1, value2, value3" are the actual values you want to insert into the respective columns.
| 3. How do I insert multiple rows of data in MySQL? | |
Ans. To insert multiple rows of data in MySQL, you can use the INSERT INTO statement along with the VALUES keyword. Here is an example:
INSERT INTO table_name (column1, column2, column3)
VALUES (value1, value2, value3),
(value4, value5, value6),
(value7, value8, value9);
In this example, each set of values enclosed in parentheses represents a row of data to be inserted. You can continue adding more rows by separating them with commas.
| 4. Can I insert data into specific columns only in MySQL? | |
Ans. Yes, you can insert data into specific columns only in MySQL. The syntax for this is as follows:
INSERT INTO table_name (column1, column2)
VALUES (value1, value2);
In this example, you specify the column names you want to insert data into, and then provide the corresponding values. Any columns not mentioned in the INSERT statement will either be assigned their default values or NULL if no default value is specified.
| 5. How can I insert data into a MySQL database using a SELECT statement? | |
Ans. You can insert data into a MySQL database using a SELECT statement by combining the INSERT INTO statement with the SELECT statement. Here is an example:
INSERT INTO table_name (column1, column2, column3)
SELECT column1, column2, column3
FROM another_table
WHERE condition;
In this example, the SELECT statement retrieves data from another table based on a specified condition, and then the result set is inserted into the specified columns of the target table using the INSERT INTO statement. Make sure that the number of columns in the SELECT statement matches the number of columns in the INSERT INTO statement.
Text Transcript from Video
hello YouTube welcome to tutorial number
28 in the PHP programming tutorial
series and before I start this video I
just need to make up one request and I
don't mind answering messages you know
it's fine
I'll answer messages any questions you
have send me a PM but there are two
things I want you to do before you
message me number one look through my
videos because the answer might already
be on a video so you don't have to wait
for me to answer and number two if you
do want to ask a short question ask it
on the comments section of the video
because that way if I answer it on the
comments then that questions or even
answered the shamone who maybe has the
same question so it helps them as well
because I have hundreds and nearly a
1000 unread messages and it is really
time-consuming for me
I don't mind though like I'm not
complaining I'm just saying it'll be
easier if you did it that way for both
of us
we'll show you all of us but in moving
on on to the video in the previous video
we looked at how to create a table
through a my sequel query in PHP and
we're going to be going back to the M
SQL a syntax again in this video and
looking at how to insert values into a
into a table that we've made so let's
just look at this users - table we made
in the previous video if we click on
click on browse actually because we got
have entries we have the ID username
password first name and last name we
have all of those in columns they're in
this table so 1 2 3 4 5 and we added a
little mark entry through the PHP
myadmin M panel here but what we want to
do in this video is actually add data
through a PHP file without accessing
this PHP myadmin that way users can add
their own entries into a database so
we're just going to click on if you
click on the accounts here back to the
main database accounts and you should
see em empty or clear on database click
that because that way we can get rid of
the mock information that we've already
got in it ok so back to the coding let's
start coding this main application ok so
the first obviously we need to create
our PHP opening closing
tags so it recognizes a PHP file we're
going to call this data up eh P okay so
we need to start this off exactly has we
started off the previous tutorial and if
you remember all we did was we created
the connection to the my sequel database
then we selected the database accounts
and then we made our own table called it
users to so what going to do as we did
in the last tutorial whoops
pants on make a variable called accounts
and that's going to be my sequel on the
scroll connect and in brackets we need
our three parameters which the first is
localhost which is the server then a
comment and then second is going to be
the username root and third is the
password - password now it's important
to note that these three values will be
different depending on what you're
working on
excuse me so my username and password is
customized to root and password yours
might be different on obviously if
you're using a external database
localhost won't work for the address
okay so underneath this you need to type
or Die and in brackets my sequel on the
scroll error and then finish that off
with a semicolon and now we need to
select our database and we this is
called accounts you might have called
your something different so we go onto
your PHP myadmin
it you'll be called up here you go to
localhost do you have a list of
databases if you remember we call those
accounts so if you are coming straight
in this video and you haven't watch a
previous one your database might be
different so you need to put whatever
the name of the databases so we type my
sequel on the score select on the score
DB and then in brackets and the first
part the first parameter is the name of
the database accounts and then we have a
comma and after that we need to put the
variable which holds our connection
which is up here accounts okay so this
is where it gets different so we're just
going to create our my sequel on the
scroll query code down here so type my
sequel on the scroll query and then in
brackets you want fist our query which
is going to be held an SQL variable
we're going to determine that in the
second don't worry and then have a
comment
and have another variable which is your
connection or PA accounts okay so now
it's time to look at the SQL syntax and
how to insert data into a table so your
first create our string variable here
which is this SQL that we're putting
inside this lip M rabbits good so it
will hold a bit of a short throat it's
kind of hid in my voice but what we need
to do to them insert data is simply type
insert into and this insert tells SQL
that we want to insert data and when we
say into after this we need to type the
name of the table and once again if
you're watching this from the previous
tutorial we named our table as uses too
but if you're watching this because
you've stumbled across this video you
need to type the name of your table
which is right here and obviously ours
is users too so we'll just type users to
insert into users - it's quite logical
when you think about it and the next
thing we need to do is specify the
fields and a table what we want to
insert it into so in brackets we need to
type all of our fields in here and it's
important to note they do not need any
sort of quotations you just type them as
plain text okay so the first one is if
we click on structure and we can see all
of the fields a first one right now we
don't need to type ID and the reason for
that is this auto increments if you look
here auto increment this will just add
its own value each time so we don't need
to use this so the first one technically
is username so if we go back under here
left in the first part of the bracket
same username and then we have a comment
remember there's no snow quotations the
second one is password so comment
password comment and the next one is
fist which is going to be the first name
comment and then the last one is last
okay so so far we just have insert into
users - it sounds logical and in bracket
which is specifying the fields that we
want to insert data into now all we need
to do is type values and then in comas
the same thing again but in this case we
need to have a
tations to specify the date you want to
enter into it so I'm going to use this
in single quotations because we have
double quotations runs variable so you
put a single quotation and then the
first value we're going to enter now
what you need to do is need to make sure
the values you enter in here match up to
the values you enter in here and by that
I mean the first in parameter the first
set of data that's here needs to be
username and then after the comma the
second there must be the password
because you can change these around you
can enter it the same way and it will
just insert like this the first one here
as the first one here second one here
second here if you know what I mean so
if not understand what that means but
just try and watch it over again so the
username we're going to insert the
username as teach me computer i'll
be--i'll username actually diabetes bit
long because we specified a short in
people limit so just type Chris as the
username and then we the have a comma
and it in brackets again in the password
we'll just put that as pass one two
three
something simple then have a comma and
then a space and then in we're going to
have a first name it's going to be Chris
and then the last value which is last
name it's going to be Johnson okay so
let's just look over this one more time
so we'll just clear on how what's
happening and we just say and say it
into users - so we're just specifying
that we want to insert into the table
litleo and see it into the table users -
and then in brackets we just specify
each field that we want to insert into
so we could take out this password and
then just have user name first and last
and then we just have three values here
or we could spot last as the second
value here and then it it wouldn't see
it pass one two three is the last name
so these are very important the way you
organize these and then we type values
and brackets we have the values you want
so username will be Chris password pass
one two three and so on
so almost forgot our semicolon here type
that there and hit save so this was
called data PHP
so if you go here you'll see we
presented with no error that means it
should have worked
if you go into here click on users too
and we have all of the information we
have here Chris past 23 Chris Johnson
you can see also inserted the ID for us
so if we just visit this again it will
insert the same ones again and you'll
see it has ideas too so this it worked
and everything was done correctly that's
how to insert data and what actually
what I'm going to do is I'm going to
show you guys how that you can customize
it so user can insert data and don't
have enough time I think I do and
actually I don't looking at the clock is
about 15 minute limit probably won't be
able to set there a lot but I'll do that
in the next video or I'll leave that
until the community videos so thanks for
watching the video guys hopefully this
helped I'm sorry for the big break but
I'm not gonna lie and say I was like
doing exams I was just been playing
modern warfare 3 the whole time and it's
it's so good I hope you guys are
enjoying the game as well so make sure
in if you have any questions as I said
look through first step is to look
through my videos second step is to
comment on this video with the question
and then if I don't get ran to see in
the comment by accident then just leave
me a PM as well so am I'll see you guys
later and peace
28 in the PHP programming tutorial
series and before I start this video I
just need to make up one request and I
don't mind answering messages you know
it's fine
I'll answer messages any questions you
have send me a PM but there are two
things I want you to do before you
message me number one look through my
videos because the answer might already
be on a video so you don't have to wait
for me to answer and number two if you
do want to ask a short question ask it
on the comments section of the video
because that way if I answer it on the
comments then that questions or even
answered the shamone who maybe has the
same question so it helps them as well
because I have hundreds and nearly a
1000 unread messages and it is really
time-consuming for me
I don't mind though like I'm not
complaining I'm just saying it'll be
easier if you did it that way for both
of us
we'll show you all of us but in moving
on on to the video in the previous video
we looked at how to create a table
through a my sequel query in PHP and
we're going to be going back to the M
SQL a syntax again in this video and
looking at how to insert values into a
into a table that we've made so let's
just look at this users - table we made
in the previous video if we click on
click on browse actually because we got
have entries we have the ID username
password first name and last name we
have all of those in columns they're in
this table so 1 2 3 4 5 and we added a
little mark entry through the PHP
myadmin M panel here but what we want to
do in this video is actually add data
through a PHP file without accessing
this PHP myadmin that way users can add
their own entries into a database so
we're just going to click on if you
click on the accounts here back to the
main database accounts and you should
see em empty or clear on database click
that because that way we can get rid of
the mock information that we've already
got in it ok so back to the coding let's
start coding this main application ok so
the first obviously we need to create
our PHP opening closing
tags so it recognizes a PHP file we're
going to call this data up eh P okay so
we need to start this off exactly has we
started off the previous tutorial and if
you remember all we did was we created
the connection to the my sequel database
then we selected the database accounts
and then we made our own table called it
users to so what going to do as we did
in the last tutorial whoops
pants on make a variable called accounts
and that's going to be my sequel on the
scroll connect and in brackets we need
our three parameters which the first is
localhost which is the server then a
comment and then second is going to be
the username root and third is the
password - password now it's important
to note that these three values will be
different depending on what you're
working on
excuse me so my username and password is
customized to root and password yours
might be different on obviously if
you're using a external database
localhost won't work for the address
okay so underneath this you need to type
or Die and in brackets my sequel on the
scroll error and then finish that off
with a semicolon and now we need to
select our database and we this is
called accounts you might have called
your something different so we go onto
your PHP myadmin
it you'll be called up here you go to
localhost do you have a list of
databases if you remember we call those
accounts so if you are coming straight
in this video and you haven't watch a
previous one your database might be
different so you need to put whatever
the name of the databases so we type my
sequel on the score select on the score
DB and then in brackets and the first
part the first parameter is the name of
the database accounts and then we have a
comma and after that we need to put the
variable which holds our connection
which is up here accounts okay so this
is where it gets different so we're just
going to create our my sequel on the
scroll query code down here so type my
sequel on the scroll query and then in
brackets you want fist our query which
is going to be held an SQL variable
we're going to determine that in the
second don't worry and then have a
comment
and have another variable which is your
connection or PA accounts okay so now
it's time to look at the SQL syntax and
how to insert data into a table so your
first create our string variable here
which is this SQL that we're putting
inside this lip M rabbits good so it
will hold a bit of a short throat it's
kind of hid in my voice but what we need
to do to them insert data is simply type
insert into and this insert tells SQL
that we want to insert data and when we
say into after this we need to type the
name of the table and once again if
you're watching this from the previous
tutorial we named our table as uses too
but if you're watching this because
you've stumbled across this video you
need to type the name of your table
which is right here and obviously ours
is users too so we'll just type users to
insert into users - it's quite logical
when you think about it and the next
thing we need to do is specify the
fields and a table what we want to
insert it into so in brackets we need to
type all of our fields in here and it's
important to note they do not need any
sort of quotations you just type them as
plain text okay so the first one is if
we click on structure and we can see all
of the fields a first one right now we
don't need to type ID and the reason for
that is this auto increments if you look
here auto increment this will just add
its own value each time so we don't need
to use this so the first one technically
is username so if we go back under here
left in the first part of the bracket
same username and then we have a comment
remember there's no snow quotations the
second one is password so comment
password comment and the next one is
fist which is going to be the first name
comment and then the last one is last
okay so so far we just have insert into
users - it sounds logical and in bracket
which is specifying the fields that we
want to insert data into now all we need
to do is type values and then in comas
the same thing again but in this case we
need to have a
tations to specify the date you want to
enter into it so I'm going to use this
in single quotations because we have
double quotations runs variable so you
put a single quotation and then the
first value we're going to enter now
what you need to do is need to make sure
the values you enter in here match up to
the values you enter in here and by that
I mean the first in parameter the first
set of data that's here needs to be
username and then after the comma the
second there must be the password
because you can change these around you
can enter it the same way and it will
just insert like this the first one here
as the first one here second one here
second here if you know what I mean so
if not understand what that means but
just try and watch it over again so the
username we're going to insert the
username as teach me computer i'll
be--i'll username actually diabetes bit
long because we specified a short in
people limit so just type Chris as the
username and then we the have a comma
and it in brackets again in the password
we'll just put that as pass one two
three
something simple then have a comma and
then a space and then in we're going to
have a first name it's going to be Chris
and then the last value which is last
name it's going to be Johnson okay so
let's just look over this one more time
so we'll just clear on how what's
happening and we just say and say it
into users - so we're just specifying
that we want to insert into the table
litleo and see it into the table users -
and then in brackets we just specify
each field that we want to insert into
so we could take out this password and
then just have user name first and last
and then we just have three values here
or we could spot last as the second
value here and then it it wouldn't see
it pass one two three is the last name
so these are very important the way you
organize these and then we type values
and brackets we have the values you want
so username will be Chris password pass
one two three and so on
so almost forgot our semicolon here type
that there and hit save so this was
called data PHP
so if you go here you'll see we
presented with no error that means it
should have worked
if you go into here click on users too
and we have all of the information we
have here Chris past 23 Chris Johnson
you can see also inserted the ID for us
so if we just visit this again it will
insert the same ones again and you'll
see it has ideas too so this it worked
and everything was done correctly that's
how to insert data and what actually
what I'm going to do is I'm going to
show you guys how that you can customize
it so user can insert data and don't
have enough time I think I do and
actually I don't looking at the clock is
about 15 minute limit probably won't be
able to set there a lot but I'll do that
in the next video or I'll leave that
until the community videos so thanks for
watching the video guys hopefully this
helped I'm sorry for the big break but
I'm not gonna lie and say I was like
doing exams I was just been playing
modern warfare 3 the whole time and it's
it's so good I hope you guys are
enjoying the game as well so make sure
in if you have any questions as I said
look through first step is to look
through my videos second step is to
comment on this video with the question
and then if I don't get ran to see in
the comment by accident then just leave
me a PM as well so am I'll see you guys
later and peace
Related Exams
About this Video
|
4.70/5 Rating |
|
Nov 22, 2024 Last updated |
Video Description: MySQL Inserting Data for Software Development 2024 is part of PHP for beginners preparation.
The notes and questions for MySQL Inserting Data have been prepared according to the Software Development exam syllabus.
Information about MySQL Inserting Data covers all important topics for Software Development 2024 Exam.
Find important definitions, questions, notes, meanings, examples, exercises and tests below for MySQL Inserting Data.
Introduction of MySQL Inserting Data in English is available as part of our PHP for beginners for Software Development & MySQL Inserting Data in
Hindi for PHP for beginners course. Download more important topics related with notes, lectures and mock test series for
Software Development Exam by signing up for free.
Description
Video Lecture & Questions for MySQL Inserting Data Video Lecture | PHP for beginners - Software Development - Software Development full syllabus preparation | Free video for Software Development exam to prepare for PHP for beginners.
Information about MySQL Inserting Data
Here you can find the meaning of MySQL Inserting Data defined & explained in the simplest way possible.
Besides explaining types of MySQL Inserting Data theory, EduRev gives you an ample number of questions to practice MySQL Inserting Data tests,
examples and also practice Software Development tests.
|
30 videos
|
|
Explore Courses for Software Development exam
|
|
Signup for Free!
Signup to see your scores go up within 7 days! Learn & Practice with 1000+ FREE Notes, Videos & Tests.
Related Searches
ppt
,MySQL Inserting Data Video Lecture | PHP for beginners - Software Development
,Previous Year Questions with Solutions
,past year papers
,Viva Questions
,Sample Paper
,Objective type Questions
,practice quizzes
,Important questions
,Exam
,Extra Questions
,study material
,MCQs
,shortcuts and tricks
,mock tests for examination
,video lectures
,MySQL Inserting Data Video Lecture | PHP for beginners - Software Development
,Free
,Semester Notes
,Summary
,MySQL Inserting Data Video Lecture | PHP for beginners - Software Development
;
Study MySQL Inserting Data on the App
Students of Software Development can study MySQL Inserting Data alongwith tests & analysis from the EduRev app,
which will help them while preparing for their exam. Apart from the MySQL Inserting Data,
students can also utilize the EduRev App for other study materials such as previous year question papers, syllabus, important questions, etc.
The EduRev App will make your learning easier as you can access it from anywhere you want.
The content of MySQL Inserting Data is prepared as per the latest Software Development syllabus.
|
© EduRev
|
Education Revolution
|
Follow Us
|
Signup to see your scores
go up within 7 days!
Access 1000+ FREE Docs, Videos and Tests
Takes less than 10 seconds to signup