Hey everyone.
So in the last two videos you have seen that things are very large.
The videos are very big.
But now you will notice that how easy do things up because until then we do not have set up the tanks.
Now everything is already setup.
So now let's move with inserting the data now in this video we will learn that how you can insert the
data in tables.
So for that one again inserting data come on will be same just the execution is different.
So at that point you are creating a table set creating a draw.
Now you're going to actually insert that some data in that.
So while working on different databases you need to change the connection while working in the same
database.
You need to change the execution Come on.
So first I'm showing without a function then we will move with function.
So just go to execute and it came out of a scholar.
Very simple just what you want here.
Insert some data.
So insert and then in two in which database you won't see data.
We have data after that when you just need two positive values.
So here we have values fences in that one according to the columns positive value serial number of Sandy
five name buggy.
And that will be in quotes because it's actually a name and double code single after that one marks.
So a hundred that will be a real save this one.
And then we had the terminal right and three.
No.
Sorry not Python 3 Python 3.
And then D.B. No.
B Why had we done David go this one successful so we'll not get any output here or here or anywhere
else as you just get the data and like database.
If I open this one my open read text added default.
We got something non understandable.
We have added bogey that is maybe this one so will not understand what is actually written here.
But we will get this thing that how you can check the data on that it is stored or not.
When we we learn about the view come on in the next video.
Now just add this one to a function so define insert
busted dots do and all this come on there because again you do not need to again and again write these
things after that open.
This is a function so that will be user input commands so of values so pass parameters there for us
to unsaved rule number denoting a number.
Then we have the name and then we have a will Max.
So Mark for Lippman and I'm taking a name full name because these same column named data and these sometimes
they get added Not every time but generally in my case they sometimes made errors.
So I'm using a different name from the column names.
So here insert into data values and then now you do not need to pass these values here or by using the
percentage as in defining these values after this one.
What do you need to do here.
Boss question marks as number of parameters you have.
So again caution marks and not be focused with that one.
So prosecution marks here and after the courts using a comma not here after defenses and before the
court after this command is finished with this court's here possible barometer read labels that is drawl.
Then we have a name.
Then we have Mark just simplistic.
And now insert and positive value serial number for name say this time bug hero and or number so remarks
again under because the bugs are an intelligent safe.
This one tried to run here but we go to the Adam function text at most two arguments for.
Given what we have done here I have buzzed three arguments here I believe Edwin try this one again maybe
that's so again getting error in that one.
Let me check that.
What's the mistake we have done do no name Mark.
Correct.
We did one for no name and mark.
So what's the thing happen here.
I need to pass the fences because the variables are more than one here.
So I require robust pencils there.
So save this one.
And now let me do that again.
David go with that one.
So that is successful No.
So here you also need to pass the bear panties because I do not focus that down are more than one variables
here.
So while we are working on more than one we just generally pass them in form of cool pulse.
If you remember.
So this one needs to be passed into tuples.
Now that is also added in that one and if guy again try to check in this one the language that would
inaudible to understand here we have bigger Hazel but are demoed.
So they are adding a day by themself so that one is buggy.
No.
Then with inserting the data in this one.
Now I'm going to move with that one baby too.
So for that one everything will be again same.
Just copy this one pasted tail and just copy this one from here.
And replace this execute Come on.
Also this one function name
get company copied let me just this one and replace it.
So there we go with that one.
Now the command for inserting something will be again same basic detail changed almost a one and just
bugger marks will be same hundred.
Now one more thing you need to do here this time in case of these kinds of databases that one is just
for local you did not require question marks here.
What do you need to pass these percentages.
So percentages percentages and percentages.
So again full shoot focus on the question marks and decode.
Now if you save this one and done it here a little discipline successful and now when you open your
database and go to the tables they maybe have different columns.
Now to see that data whether the data is added here or not just go to this school.
So not this one these tools where they do.
There you can write the commands that you are writing in your atom also to add or edit the things.
So for selecting the data to view we just do select star Stallman everything from and we are working
with data also data.
So here we have the data.
So select start from data now click on drone.
Here we have this one from and there we go the output.
So here we have two inputs Bulger and Bulger with hundreds and hundreds.
It seemed all number maybe I have executed twice that one.
So this is how you can have data here.
If I add one more data to that one say rule number two and this one say super and Max will be dead save
this one go to terminal run that again and now get two data.
So here we have our data again.
If you run this one again we get this super also.
So here now super is added indictment and this data is also readable instead of deadpan.
So this is about that how we can insert data in our database.
You can even add to any paragraph also informal string just pass any paragraph in between that will
be added there.
So this is about inserting data will continue about realizing that data in the next video.
So thanks for watching.
See you there.