1 00:00:00,150 --> 00:00:05,160 Next up, we're going to talk quite a bit about different data types that we have access to in my SQL. 2 00:00:05,190 --> 00:00:09,420 We've basically been working with two and only two data types. 3 00:00:09,420 --> 00:00:16,470 We have INT for integers, whole numbers, and then var cars or var chars, right, for pieces of text 4 00:00:16,470 --> 00:00:18,150 that are variable in length. 5 00:00:19,110 --> 00:00:25,350 However, there are way, way more data types that we have not seen and frankly that we will not see 6 00:00:25,350 --> 00:00:28,650 because some of them are really niche, some of them are really similar. 7 00:00:28,650 --> 00:00:32,520 So I'm going to try and show you in this section some of the most important ones you should know about. 8 00:00:32,520 --> 00:00:36,420 But if you went to the docs, you looked at the data types section on the docs. 9 00:00:36,420 --> 00:00:37,890 I mean there are so many different types. 10 00:00:37,890 --> 00:00:40,650 We look at any of them, even just string data types. 11 00:00:40,650 --> 00:00:45,780 We've got cha cha cha binary var binary blob text enum set. 12 00:00:45,780 --> 00:00:48,090 We're not going to go over the majority of these. 13 00:00:48,090 --> 00:00:53,730 We're actually really just going to look at CHA and var Carr or Cha have got to be consistent there 14 00:00:54,240 --> 00:00:56,730 because those are the most commonly used. 15 00:00:56,730 --> 00:01:02,520 That's not to say that these others are not worth knowing about, but they just come up way less frequently. 16 00:01:02,520 --> 00:01:04,290 So I just want to set that expectation. 17 00:01:04,290 --> 00:01:05,910 Same thing with numbers. 18 00:01:05,910 --> 00:01:11,580 We're going to see quite a few numeric data types, but there are way more that we're not going to see. 19 00:01:11,970 --> 00:01:12,750 We'll see. 20 00:01:12,840 --> 00:01:16,770 We've seen integers, we're not going to really talk about small and tiny and medium and big. 21 00:01:16,770 --> 00:01:22,980 INT We'll talk about some of this stuff here, decimals and floats and doubles, probably not bits. 22 00:01:22,980 --> 00:01:24,750 So that's all I want to say up front. 23 00:01:24,750 --> 00:01:25,950 There's a lot of data types. 24 00:01:25,950 --> 00:01:30,900 We can use them whenever we want, when we create a table, but I'm going to focus on the ones that 25 00:01:30,900 --> 00:01:32,790 I think are worth our time. 26 00:01:33,270 --> 00:01:38,790 And then if you get far enough with my SQL, you're working on a project and you realize maybe I should 27 00:01:38,790 --> 00:01:45,180 use tiny int here because you suddenly have to care about storage size, Then you can look into tiny 28 00:01:45,180 --> 00:01:49,680 ints, but when you're starting out, when you're just learning things, it's just overkill to to try 29 00:01:49,680 --> 00:01:51,270 and show you all the data types. 30 00:01:51,270 --> 00:01:55,440 So we're going to talk about numeric types, we're going to talk about string types, and we're going 31 00:01:55,440 --> 00:02:00,120 to talk about something entirely new date and time and time stamps, data types. 32 00:02:00,120 --> 00:02:06,480 We haven't seen anything with dates and times, but that is a pretty commonly used type or family of 33 00:02:06,480 --> 00:02:07,740 types in the real world. 34 00:02:07,740 --> 00:02:14,070 If we're working with comments or posts or anything Internet related, social media related, we probably 35 00:02:14,070 --> 00:02:15,270 store all sorts of things. 36 00:02:15,270 --> 00:02:16,740 Last login time. 37 00:02:16,740 --> 00:02:23,400 The time something was posted, the date somebody was born on, or their birthday, or the date somebody 38 00:02:23,400 --> 00:02:24,780 joined our website. 39 00:02:25,260 --> 00:02:31,470 All sorts of things that we track or even just the last time some piece of data was changed, we could 40 00:02:31,470 --> 00:02:35,100 track that using these different data types that we're going to cover. 41 00:02:35,100 --> 00:02:40,620 So that will be a pretty significant section of this section, a significant chunk of the section. 42 00:02:41,400 --> 00:02:47,010 And I think without further ado, I'm going to shut up in this video and let us move on in the next 43 00:02:47,010 --> 00:02:51,660 video to start talking about our first new data type char or car. 44 00:02:51,690 --> 00:02:52,470 That's coming up.