Hello and welcome to this lecture, where we are going to create a database and also table to start
our data about the products.
The first step is to open my school work bank.
We installed the last lecture.
We need to click this button to create a new connection.
We call with products and there is no need to change any of the parameters here.
See that we are connecting should these IP number, which means our local machine, we can test the
connection.
Now you need to Typekit the passwords you defines when you installed my Eskil server.
So I will put the here my best words click OK.
You can see this message that indicates that the connection was made successfully.
If you have any problem about this connection, you need to make sure that the My ASCII server is running
here.
Now let's click.
OK?
We can't see this information here.
Double click.
And now we can create a new database.
I will write with this code.
Great database.
I will call products.
Then we can click this button here.
See this mass safe that the database was successfully created.
Now we can click Scan once.
Refresh all, see, that's our new database is already created, we can see more information here,
for example, there is no tables.
Now we will create a new table, which we started.
They thought about the products.
You can double click here.
See, that's now.
The name of the database is in bolds, which indicates that all the components that we will buy here
will be executives in these products database.
Now let's type, create label products, and we need to specify each one of the columns.
The first one product I did, it will be an integer.
No, not no.
And the type how to increment.
It means that when we add products, should this table, each one will have unique I.D. and these unique
ID will be generated automatically by my scale.
Now let's define the next column product name.
It will be very sharp with the maximal size of 50 sharp views.
We are going to start storing data.
Also not know this base that the product occupies in the truck floats.
Not know the price of the product floats.
Not to know.
Now let's define a new column, which will be what quantity and we are going to start.
How many units we have off each one of the products in our last implementation.
We didn't concede there the quantity.
However, a real company has many products and many units of each one of them, so we can consider the
quantity to fast our genetic algorithm.
Now we need to create the primary key constraint how we buy basic products product IP.
This is the name of the primary key.
Let's define here primary key equals product I.D..
We are associating the primary key of this table with these two increments column here, which means
that we cannot have, for example, two products with this same idea.
For example, product one two, three four five and so on.
Now we can select only this part of the codes.
Click this button.
We can see this green massage here.
Let's refresh the data sets.
And now we can see our table.
If you want to visualize the data, we can type select all colors from products.
Let's select only this part of the code.
Run it.
See, that's the table is empty now.
When these two ads, each one of the products to this table should do that.
We can implement and larger comments.
Insert info products.
We need to specify the colors.
The first one product, name, space, price and quantity.
We don't need to specify the first column because it will be automatically generated values.
And now we just need to type the name of the products.
For example, the first one refrigerator a day and the space zero point seven five one the price nine
nine nine point ninety.
And the quantity for this product, only one we can select and run this code.
We can see the green message here.
Now we can select and run these other codes to visualize the data.
See, that's the first product is already added to this table.
We can see the name, space, price and quantity, and we can see here products a day that was automatically
generated.
Now we need to copy and paste this same code to hear these separate Coleman's two ads.
All the products that we were using before are we all just faced this code here?
We already have all products.
You can get these scripts in the course materials, so you don't need to type all this code.
Now let's select all the codes.
See, that's that are different quantities here, for example, one than two five one four.
And so one, let's run these codes.
We can see the green message.
And finally, we can run these other codes to see the results.
See that now we have all the products, according to our case study.
And in the next lecture, we are going to create a new project in by Shaam and we will pass to the code
that we implement as before.
So there.