1
00:00:00,420 --> 00:00:01,020
Welcome back.

2
00:00:01,440 --> 00:00:06,090
Now, what I'm going to do is that I'm going to add the tables that we need to the database.

3
00:00:06,480 --> 00:00:11,940
So remember the database that I created, which is BHP project, BHP underscore project.

4
00:00:12,330 --> 00:00:14,430
So in order to give you the tables, you have two options.

5
00:00:14,820 --> 00:00:18,090
The first option is to type the name of the table and then manually.

6
00:00:18,480 --> 00:00:26,520
You need to type in the name of columns and specify all of these things manually or you can use SQL.

7
00:00:26,880 --> 00:00:33,780
So I have here this code that will allow me to clean this table quickly without the need of typing everything.

8
00:00:34,230 --> 00:00:38,940
So, for example, I have here the product table which will have the product ID, the product name,

9
00:00:38,940 --> 00:00:44,610
the category, etc. We have also orders order, order items, users, all of these things.

10
00:00:45,180 --> 00:00:51,210
So instead of typing all of these and creating all of these tables manually, I'm going to copy this.

11
00:00:51,870 --> 00:00:52,290
This.

12
00:00:54,160 --> 00:00:58,270
This five is good and then I'm going to paste it in the scale.

13
00:00:58,270 --> 00:01:04,420
You need to select first your database, this database B2B project, and then click on you will and

14
00:01:04,420 --> 00:01:10,270
then you need to tie, you need to paste record here, you need to base that code here and then click

15
00:01:10,270 --> 00:01:10,840
on Go.

16
00:01:11,200 --> 00:01:13,570
And this is going to insert these tables.

17
00:01:13,900 --> 00:01:18,100
Now if you click on BGP project, you should find that we have here four tables.

18
00:01:18,550 --> 00:01:19,900
Let's examine one of them.

19
00:01:19,900 --> 00:01:21,370
So I'm going to examine the products.

20
00:01:21,820 --> 00:01:28,270
So as you can see, the products, the products table has any name, category, description, etc..

21
00:01:28,270 --> 00:01:32,590
So this is how we can get the table quickly by using a scale.