Hello, in this video I am going to show you how to create a database and a table. Not using code will actually you know do some of that later on in the my SQL section of this series. But using PHP, my admin first of all in your panel, make sure you have my SQL started. If it is great, if not start it and then we're good to go. You may need to start in a different way for your online server. You'll feel free to contact your server you know your host provider, ask them to do it should already be activated, they'll probably be a specific URL that you need to access it if you haven't any trouble with that feel free to shoot me a message and you know let me know what hos providing you with and I'll you know have a look see if I can find a solution.
So to get to it, you can type in localhost you know what you usually would wave the port number to access your website for slash PHP my admin like so and it will take you to this little page. So I'll say get very used to it, because this is what you'll be using a lot locally and online as well. So this will allow us to create databases already some databases created here. So the PHP myadmin one, and inside here there are tables if I go to use it, for example, they are no users. But let's go to the homepage. We can go to databases, and we can create a new database name.
And do I want Latins Swedish. Okay, weird. And a while we'll say Latin one Swedish she should be UTF English range leave it up. UTF generally is really where you should want to not say stuff like that. Okay, so if we say, epic database and click Create, that's the database created, that's a right over here at the moment, it's empty, because there are no tables in there. So we need to create a table.
So we could so this database, usually you'll have the one database for your website, you can have multiple tables in there. And you could have a table for users will have a table for let's say, a social media site, a table for comments, table for posts, table for, you know, tracking or the likes and thumbs up on a website, for example, stuff like that. So this is number column, basically, the manage data you're storing. Don't worry, you can add extra columns and take away columns, or like data if you have you know, some in mind. You can just put them right yeah, I'm going to put two for now and the name I'm going to put up So if I go to go is created it. And now you want to tell it, what each, you know column is what each piece of data is.
One should always have his ID keep that into jack. And you don't want to default, you want to go to index primary. So yes, click Go. So this primary and unique, unique index is well it can't be, what's the code, you can't have a duplicate row in your table with you know, with a value in another row, that's the same, whereas primary is the same as unique, but it is the primary one used to identify particular row so you always have one primary and there'll be unique as well. We could have multiple unique and do AI which is auto increment. So you're basically just start off with 0123 and you know, etc.
We don't need to really mess with The US for what we need for now. And I'm going to put this username. And I'm going to put this a VAR char which means a variable Kota. Essentially, you can put strings here, and then a bunch of different formats like text date, now integers, tiny integers. So really small number two big NT can store a really big number. And the reason you might have a small one compared to a big one, if you know you're only going to store small numbers, then it will, you know, reduce the amount of space that you need.
And if you really need really big text, you can go to stuff like long text binary, and even stuff like blob and non blob, which is essentially allows you to elegancy store actual gigabytes worth of data and the lock down this bar chart, and we produce MPs or per length of 32 because either names usually aren't too long. There we go. So if we click Save That's our table created five go to growth. This shows us all is at our table. And there's nothing there because we haven't actually added any, you can insert data here as well. And we'll actually be inserting it using code and we'll be viewing it all in here.
So over the next few videos, we'll be connecting to the database in code. We will be adding data to it. We'll be doing a whole heap of stuff, the really cool stuff. Any questions, feel free to pop me a message and as usual, I look forward to seeing you in the next video.