So as I just mentioned in the previous video, in order for us to all be on the same page and get the
same results, we kind of need to drop everything and start over with a new table.
So it's going to be a very simple table.
I'm just going to give you a couple of lines of code.
You either type yourself or copy and paste them.
That way we'll all have the same results when we select things or when we update things or delete things.
So we're going to drop our catch table.
I have, I think, a lot of tables called cats something.
Let's look at our tables.
Yeah, cats, cats, two cats, three cats, four.
There's a lot of cats here.
Let's plus all the unique cats.
Anyway, let's just drop table cats, plain old cats, and then we're going to recreate it.
Now, I recommend that you just copy this and paste it or it's not too bad.
You could type it out.
Just make sure we have name, breed and age and some ID that's going to auto increment and I'll copy
and paste that over here.
Hit enter Describe table cats or just describe cats.
Looks good.
And then the most important part is to insert all of these rows.
So it's what, 7 to 8 rows that I'm providing just some basic cats that have a name, a breed and an
age.
But this will allow us to have some data in common that we can work with and get the same results with,
hopefully.
So I did a bulk insert there and let's just use what we know so far.
Select Star from Cats.
We should see seven cats.
They all have a cat ID and then they all have a name, breed and age.
So hopefully you did that.
You can find this code in the slides, but you can also find it just following this video as a resource.
So either way, copy and paste it or if you're adventurous, type it yourself.
In the next video, we're going to talk about the are of crud, which is reading.