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.