Welcome back.
Let's go back into our database.
We've just created our users table, but now we want to actually insert some information.
How can we do that?
Again, using Eskil, we have the insert into command that we're able to insert into whichever table
name we want, we're going to specify the column and then the values of each of those respective columns
and always ending in a semicolon.
I also want to emphasize that with skill, the capitalization is just a standard, but if I made this
lower case, it will still work its case insensitive.
So looking at our database, we have name, age and birthday.
Let's insert something.
We'll say that we want to insert into.
Users.
Column one will be name.
And then we have.
H.
Birthday.
And no, you don't have to insert every time into every column, you can just change a name if you want.
All right, name will be.
Andre.
Value will be thirty one and then birthday will say is if you remember the day syntax if I open up here.
Is this year, month, day, so I simply do 19.
We're going to make myself really old.
We'll say January 25th.
Press enter.
I get insert awesome if I do die again.
I see my table, but how can I see the value that I just entered?
Well, first, let's check here, let's check with our gooey.
Click on content, select users and look at that name, age, birthday, I have Andre thirty one with
my birthday.
Very cool.
Now, how can we grab this information?
Again, a school syntax is select.
And we want to say what we want to select in our case, we can say name, age, birthday from and then
the table name in our case, users, semicolon, press, enter and look at that.
I get Andre Age.
Thirty one birthday.
If I want to just grab the entire columns without.
Spelling out everything.
Imagine if we had tons of columns, we can use the wild card symbol of Star that's shift eight to get
Star and I get the same thing.
Very cool, by the way.
With school.
We can actually run these queries here, see how he already has select, I can say select star from
users and he even gives me nice coloring press center or press semicolon and run query and look at that.
It gives me the table for me.
And it also has the history, which is really, really nice.
Let's add a few more users here.
I'm going to insert this time somebody else, I'm just going to change a few things.
41 and.
Sally.
Inserted, if I select staff from users, I have Andre and Sally going back here, Ron query, I have
Andre and Sally in the database.
How cool is that?
All right.
We know how to create a table.
We know how to insert into a table, and we know how to grab this information.
We can already start picturing what powers we can have now with our final project.
But there's still a few more things we want to learn.
For that, I'll see you in the next video by.