1
00:00:01,100 --> 00:00:06,110
Hello and welcome to this video and this video, we are going to create a database, we are going to

2
00:00:06,110 --> 00:00:07,940
add tables into the database.

3
00:00:07,970 --> 00:00:13,310
We are going to access and add records to the table with the help of a school.

4
00:00:13,850 --> 00:00:17,240
So let's create the database first.

5
00:00:17,240 --> 00:00:23,360
So to create the database, you will have to make sure that you write the proper name of the database.

6
00:00:23,660 --> 00:00:26,380
So you have to select the name of the database.

7
00:00:26,390 --> 00:00:30,560
I am selecting you admire is a name of my database and click on CREATE.

8
00:00:30,920 --> 00:00:35,160
So once you create your database, you will land onto this page.

9
00:00:35,180 --> 00:00:40,000
This page is a create table page if you want to create table.

10
00:00:40,020 --> 00:00:45,750
So you have to write down the name of the table and the number of column you want into your table.

11
00:00:46,130 --> 00:00:50,600
So I want three columns and the name of the table should be notebook.

12
00:00:51,500 --> 00:00:52,580
So you're right.

13
00:00:52,580 --> 00:00:59,220
Click on Go and then once I get on go, I am on to the next page, which is the structure of the table.

14
00:00:59,630 --> 00:01:06,740
So if you remember that I selected three columns, so I got three input filled over your 123 wherein

15
00:01:06,740 --> 00:01:09,310
I'm going to write three column names.

16
00:01:09,740 --> 00:01:13,370
So the first column name I want is serial number.

17
00:01:13,940 --> 00:01:15,710
So I type serial number.

18
00:01:15,860 --> 00:01:21,350
The second column name should be name and the third column name should be attendance.

19
00:01:22,490 --> 00:01:31,190
As an example, I'm going to replicate the same table structure, so the first day that I should be

20
00:01:31,190 --> 00:01:36,230
in, I want serial number to be an integer value and the last two to be very good.

21
00:01:37,510 --> 00:01:43,750
If you don't like the length and if you try to click on go, it will say that you need to select a valid

22
00:01:43,750 --> 00:01:44,710
length sword.

23
00:01:44,710 --> 00:01:49,450
So the maximum allowed length for the serial number should be ten.

24
00:01:49,960 --> 00:01:55,430
And for rest, while I'm selecting 50 50, you can select anything as per your requirements.

25
00:01:56,020 --> 00:01:59,120
This is not compulsory and then you can click on go.

26
00:01:59,410 --> 00:02:06,270
So if you see that my table notebook is been created, if I go to ask you will the query is auto generated.

27
00:02:06,280 --> 00:02:14,980
That is select start from notebook, which means select star means all the records from the table.

28
00:02:14,990 --> 00:02:16,510
That is notebook.

29
00:02:18,660 --> 00:02:19,980
And I hate to go.

30
00:02:21,130 --> 00:02:28,600
So when you go, you will be able to see the table, which is an old book, so you're I have not inserted

31
00:02:28,600 --> 00:02:34,690
any record or values into the table, so I am seeing only the structure of the table with three columns

32
00:02:34,690 --> 00:02:37,100
that the serial number, name and attendance.

33
00:02:37,630 --> 00:02:40,870
So now I want to insert the value into this table.

34
00:02:40,880 --> 00:02:43,420
So you have to go again to the school.

35
00:02:44,530 --> 00:02:49,050
If you do not know the syntax of insert, no need to worry.

36
00:02:49,330 --> 00:02:56,050
You can click on this button insert and you will automatically get the syntax of the insert query.

37
00:02:57,170 --> 00:03:06,440
Now, I'm going to be adding values to this new book table, so the first record should be one is first

38
00:03:06,440 --> 00:03:07,940
column is serial number.

39
00:03:07,940 --> 00:03:13,670
The value assigned to the first column number should be one to the name.

40
00:03:13,670 --> 00:03:15,890
It should be written for attendance.

41
00:03:15,890 --> 00:03:17,060
It should be present.

42
00:03:17,390 --> 00:03:24,790
This should be my first record, serial number one name to and attendance to be present.

43
00:03:25,220 --> 00:03:32,120
Make sure that when you select a record and when you insert that value into the query, make sure to

44
00:03:32,120 --> 00:03:38,090
put it into the single core so that it works perfectly and you have to go.

45
00:03:40,540 --> 00:03:47,500
As you see, when Roy's been inserted into the database now, I'm going to be adding two more records

46
00:03:47,500 --> 00:03:48,570
into my table.

47
00:03:48,850 --> 00:03:56,290
So as you can see, if I now select Start from notebook, so I see one record which is inserted right

48
00:03:56,290 --> 00:03:56,620
now.

49
00:03:59,690 --> 00:04:08,990
So now I'm adding second record that is serial number to name Shifra, and attendance should be Epson.

50
00:04:10,410 --> 00:04:11,360
Click on Go.

51
00:04:13,870 --> 00:04:20,720
OK, great, so second record has been inserted into my table, if you want to see the table again at

52
00:04:20,770 --> 00:04:26,680
the very select start from Table Belém or else you can keep on adding the records once you are done

53
00:04:26,680 --> 00:04:30,090
at the end, you can see all the records which you have inserted.

54
00:04:30,550 --> 00:04:31,590
So I don't go.

55
00:04:32,380 --> 00:04:34,480
I am done with adding three records.

56
00:04:34,490 --> 00:04:39,240
So now I'm going to see whether the table is been updated or not.

57
00:04:39,250 --> 00:04:45,640
So select start from your table so your eye can see if the table is being added with three records,

58
00:04:45,640 --> 00:04:46,780
which I have added.

59
00:04:48,410 --> 00:04:55,800
So, yes, you can see three different record has been added to my table when you click on venue, very

60
00:04:55,880 --> 00:04:58,390
select star from the table.

61
00:04:58,670 --> 00:05:00,580
So this is it for this video.

62
00:05:00,590 --> 00:05:06,710
We have learned how to create a database, how to create a table, how to select the data type for the

63
00:05:06,710 --> 00:05:12,080
particular column, as well as how to see the database.

64
00:05:12,080 --> 00:05:20,030
What all you have created using a very select start from table is the very simple syntax of this school.

65
00:05:20,570 --> 00:05:21,650
Thank you so much.
