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.