All right.
So we have allegedly inserted at least two rows into our cat's table.
How do we know that we actually have those values in there?
Did something go wrong?
Did we accidentally insert name into the age column and age into the name column?
How do we verify that it worked as we want it to?
Well, one of the problems with a lot of programming from a teaching perspective is that there's no
obvious order to teach things in.
Things are very interconnected.
I'm teaching you how to insert in this section, but we have to be able to know if our inserts work.
So I have to show you a command from the next section, which is all about select.
So the next section we'll dive a lot more into select.
But for now, this is the basic most basic usage of select select star from some table name in our case,
cats.
This just tells SQL.
Give me everything you have in the cat's table, so let's try it.
Select star from Cats and we see two cats.
So we have name and age.
They're properly set up, right?
So the ages are inserted in age, the names are inserted into name, it's not reversed or anything and
we have to it's looking good.
So of course we can do the same thing.
Let's do it in the SQL workbench.
This time, if I do select star from Cats, this is commented out, so it looks like I can even just
delete it.
But if I run this here, click the lightning bolt.
We see the same values.
It's a little different looking than it is over here, but it's the same thing, right?
Blue Steel five, Jenkins seven.
Okay, so that's all you need to know about select four now.
But there's a lot more that we will learn and we'll write some very complicated selects later on.
But again, this just says, Give me everything from the cat's table.