All right, so before we move into the new part of this course, I would like us to create a new table
because that is one of the very necessary things we need.
And let's go ahead and go over to macro.
And then we're going to create a new table.
From here I'm going to leave the ID then I'm going to remove all these.
Then I'm going to change this first name.
We're going to create a table for a phone.
Right.
I'm going to change this to brand.
And I'm going to change this to school and look for a mobile brand.
So over here we see a mobile brand.
So it is sunny Samsung Apple which is that.
And then we'll look for a model for the phone.
And we'll go over here and scroll down to model.
And we see mobile device model.
The next thing is the price of the phone.
So let's go ahead and add a other prize for this was so we go over here and we move to money, and that
is where we have money, because you are now going to be looking for prize.
Under here there is no prize here.
So we go and click on money.
And now we go ahead and choose the range.
And let's go ahead and say is between uh, maybe 10,000 and uh dollars or we go ahead and uh, choose
that between 10,000 to $100,000.
I think that would be okay.
And, uh, we can go ahead and choose that to be initialize.
All right.
Now we go over here and now we're going to generate 1000 row as usual.
And I will go ahead and choose our SQL.
And let's go ahead and give that a name.
And that should be phone then a good table right here to create the table.
And let's go ahead and generate the Debtor.
And this will start generating.
And down here we can see that this is what we have right now.
Let's go ahead.
And now we have a phone created for us right in here.
And we need to open up this using the VS code so we can be able to see how it looks like.
So this is our VS code.
And we have our students go ahead and open a new file.
Go ahead and open a new file.
And uh go ahead and click on this.
And we have a phone dot SQL.
And this is where we have our and we need to import these.
Or we need to uh make some changes right in here.
All right.
Now let's go ahead and say that the brand is going to be not null.
Right.
And uh, the model is also going to be not null.
And then the price will also be not null unknown.
we also clean and make the ID is great to be the big area, right?
So it will Autoincrement assay is going to be big area and not know, and then it's going to also be
the primary key.
All right.
Now we have this.
It's time for us to go ahead and upload or create this table and our database.
So let's go ahead and kick off immediately.
So first of all save your file and go over to forms.
And uh uh copy the parts.
And once you copy the parts you go over to maybe your notepad and press that.
Then you remove all these and remove these.
They change all these to file for slash.
And this is also for slash.
And then this is also for slash.
Now let's go ahead and copy this.
So copy whatever you have here.
And then we go over to this place and then we try to import that.
But I always love using my SQL shell for these.
So all I need to do is to put a backward slash I remember backward slash I and then you go ahead and
press this.
But that is what you need.
And once you do that we go ahead and import it.
So let's go ahead and just hit enter.
And it says users.
No such file or directory exists.
So it seems we omitted one of the backward slash one.
We actually did that.
So what we need to do is uh let's go over to displays and add back one of the box of four slash.
Right.
So that should be a forward slash here.
And we go ahead and try it again with a.
Right.
And then press this again and let's go ahead I hit enter.
And now we have this file inserted for us.
And now we can go ahead and see backward slash D and now the name of the table is, uh, phones.
And uh, let's go ahead and open up the VS code and make sure that is what we have.
So that is phone and not phones.
So go ahead and hit enter.
And you can see that we have this table created for us.
We have the ID, we have the brand.
We have the model.
We have the prices the price.
And that is cool.
All right.
So you can simply go over here now and uh, check your select all from phone and uh, execute this query.
And this is what we have.
So that is cool.
Go ahead and pull it down.
And uh, you can also download this file app with that under source folder so that you can actually
download that from there.
Or you generate that by yourself.
That is no problem.
So thank you.
And I'm going to see you in the next video lecture.