1
00:00:00,610 --> 00:00:01,270
Welcome back.

2
00:00:01,569 --> 00:00:03,010
Let's go back into our database.

3
00:00:04,740 --> 00:00:09,270
We've just created our users table, but now we want to actually insert some information.

4
00:00:10,230 --> 00:00:10,950
How can we do that?

5
00:00:12,130 --> 00:00:21,190
Again, using Eskil, we have the insert into command that we're able to insert into whichever table

6
00:00:21,190 --> 00:00:28,870
name we want, we're going to specify the column and then the values of each of those respective columns

7
00:00:29,200 --> 00:00:31,120
and always ending in a semicolon.

8
00:00:32,080 --> 00:00:38,800
I also want to emphasize that with skill, the capitalization is just a standard, but if I made this

9
00:00:38,800 --> 00:00:41,660
lower case, it will still work its case insensitive.

10
00:00:43,150 --> 00:00:47,380
So looking at our database, we have name, age and birthday.

11
00:00:47,650 --> 00:00:48,640
Let's insert something.

12
00:00:51,130 --> 00:00:53,380
We'll say that we want to insert into.

13
00:00:56,030 --> 00:00:56,630
Users.

14
00:00:59,230 --> 00:01:01,180
Column one will be name.

15
00:01:03,220 --> 00:01:04,420
And then we have.

16
00:01:05,480 --> 00:01:05,990
H.

17
00:01:09,940 --> 00:01:10,510
Birthday.

18
00:01:13,740 --> 00:01:20,340
And no, you don't have to insert every time into every column, you can just change a name if you want.

19
00:01:22,590 --> 00:01:24,420
All right, name will be.

20
00:01:27,290 --> 00:01:27,920
Andre.

21
00:01:30,600 --> 00:01:41,070
Value will be thirty one and then birthday will say is if you remember the day syntax if I open up here.

22
00:01:43,190 --> 00:01:48,920
Is this year, month, day, so I simply do 19.

23
00:01:49,950 --> 00:01:51,450
We're going to make myself really old.

24
00:01:53,280 --> 00:01:55,980
We'll say January 25th.

25
00:01:57,940 --> 00:01:58,600
Press enter.

26
00:01:59,810 --> 00:02:05,030
I get insert awesome if I do die again.

27
00:02:06,340 --> 00:02:10,750
I see my table, but how can I see the value that I just entered?

28
00:02:12,170 --> 00:02:15,320
Well, first, let's check here, let's check with our gooey.

29
00:02:17,840 --> 00:02:25,160
Click on content, select users and look at that name, age, birthday, I have Andre thirty one with

30
00:02:25,190 --> 00:02:25,850
my birthday.

31
00:02:27,300 --> 00:02:27,910
Very cool.

32
00:02:28,570 --> 00:02:30,800
Now, how can we grab this information?

33
00:02:33,790 --> 00:02:37,210
Again, a school syntax is select.

34
00:02:38,720 --> 00:02:47,180
And we want to say what we want to select in our case, we can say name, age, birthday from and then

35
00:02:47,180 --> 00:02:52,370
the table name in our case, users, semicolon, press, enter and look at that.

36
00:02:52,820 --> 00:02:54,440
I get Andre Age.

37
00:02:54,440 --> 00:02:55,610
Thirty one birthday.

38
00:02:57,150 --> 00:03:00,390
If I want to just grab the entire columns without.

39
00:03:01,740 --> 00:03:02,880
Spelling out everything.

40
00:03:02,910 --> 00:03:11,340
Imagine if we had tons of columns, we can use the wild card symbol of Star that's shift eight to get

41
00:03:11,340 --> 00:03:14,160
Star and I get the same thing.

42
00:03:15,740 --> 00:03:17,300
Very cool, by the way.

43
00:03:18,860 --> 00:03:19,900
With school.

44
00:03:21,170 --> 00:03:27,920
We can actually run these queries here, see how he already has select, I can say select star from

45
00:03:28,460 --> 00:03:37,210
users and he even gives me nice coloring press center or press semicolon and run query and look at that.

46
00:03:37,490 --> 00:03:38,990
It gives me the table for me.

47
00:03:39,890 --> 00:03:43,490
And it also has the history, which is really, really nice.

48
00:03:45,120 --> 00:03:46,620
Let's add a few more users here.

49
00:03:50,260 --> 00:03:55,420
I'm going to insert this time somebody else, I'm just going to change a few things.

50
00:03:56,920 --> 00:03:58,180
41 and.

51
00:03:59,600 --> 00:04:00,200
Sally.

52
00:04:01,340 --> 00:04:10,220
Inserted, if I select staff from users, I have Andre and Sally going back here, Ron query, I have

53
00:04:10,220 --> 00:04:12,380
Andre and Sally in the database.

54
00:04:12,980 --> 00:04:13,800
How cool is that?

55
00:04:14,660 --> 00:04:15,140
All right.

56
00:04:15,170 --> 00:04:16,610
We know how to create a table.

57
00:04:16,820 --> 00:04:21,050
We know how to insert into a table, and we know how to grab this information.

58
00:04:21,230 --> 00:04:26,120
We can already start picturing what powers we can have now with our final project.

59
00:04:26,780 --> 00:04:28,600
But there's still a few more things we want to learn.

60
00:04:29,670 --> 00:04:32,640
For that, I'll see you in the next video by.

