MySQL Tutorial for Beginners | How to create database and add table in XAMPP using MYSQL

[Music] hello everyone I think you all have installed exam software already so let's open it and start the first two and after you have started this then minimized it minimal this and open any browser like Mozilla Firefox or Chrome browser I am using Chrome browser for this you can use any of them then write localhost then add a backslash and then PHP myadmin you don't need any internet for this let's press the database and then create database here at the database name there's a library management system lms - and then press create and here our LMS - database have already been added and you can just go to SQL and write the SQL code for creating table or you can go just you can just go to the database and then create the tables from here this is actually more easier than the SQL code so I will just write it make the table from here here let's the student is our table name and we will just have four columns you can have any number you want to and we are just doing this for learning how to use them so use the personal and then had any field name that you want to then a datatype poker and because this is our character type the name will be character type so we are using this data type and then give length hundred then last name the data type will be same because we are using character as input 100 then the user name Linton do that idealism then roll it will be integer type because this is digit and then give length then press up in the right corner and after that you can see in the restructure you can see the fill time of our table or column name of our table so we can just modify them here or add or delete some column or or actually you can just delete the whole table from there I was I will like to show you there later then if we go inside our table you can see four columns but we don't have any value because we have not inserted any value here so let's go to insert from the our purple and then insert the value let's keep something simple this 3 will be character type and then another will be integer type value then please go and you can see that here is some SQL code you can just write like this in the SQL search on top to insert or you can just insert it manually and hear the message show that our battle happiness already know table and from this we can actually generate the PHP code to this code will be used in our main core and when we open the table you can see our that will have been inserted and we can actually see them now and you can insult from here too and you will see the format here automatically if you click on this insert you see the insert format is here you just need to add the value you can see the format of update select that way you can easily modify them to others insert some more values in our table you here we can see the format how we need to give the value as input from the SQL code and you see our second value is also inserted now let's give one instance one value by writing SQL code let us click on the insert and take the format first and then we need to change the values first let's delete this value formats and then we need to give the values here first three will be characters and the last one will be digit because that was our integer type value after it is done we can just press go and you see the message our value have been inserted so now if we go to the table we can see this fellow and if we need this code then we can just press on this and now you see the table is showing here and here inside this part there is a code here select star from students so this showing it this is actually showing the all the value from the table student so here this asterisk or this star sign actually is used for showing all the value so if we want to see a particular columns value so we will use that columns name here let's say we want to see the username column this will not make any change inside the table this way this is just for showing the value and nothing will be modified or altered in the table please can just see this according to our liking son we can use this inside our website too by changing these codes like this now I will show you what we need to do when we are when we will work on our main website and after this you can actually select one particular value one element from this column too and like if you write well then first name equal to X then you can say that whose first name is X that that person's username will only be shown here okay then you can get the PHP code too and you can use this inside the website in your PHP code and when you go to the table you see nothing is changed all the values are actually like the previous values that were under that we have been stuff inserted and if we go to our database again and go to the structure of our table you can actually deal it any column if you want to or add a new column if you want to add like we want to delete our role column click on drop and then okay you see the column is deleted if you go to the table you will see only three column here and then if we want to add another one after the username then you need to go here if you want more than one then add the numbers there and press GO then here you need to add the name just a roll type will be integer and add a length and say ok you see the table have been altered successfully so now if you go there you can see the column and but the value will be 0 because there is no value given now we just created this column added this new column here so you will see only 0 and the value now go to the operation if you want to delete the whole table or if you want to delete the values inside the table and keep the column name then you need to press truncate or delete the table like if we want to delete we will press it and then okay you see the database if we click on the database there is no table here and if we want to delete the database we will need to go to operation and there in the red data you can see drop the database if you did drop the database then you can stay you can see the database anymore and later I will actually show all these users first you need to practice all this by yourself and see if you can see the column and see the particular value if you use where username is something where role is something you can find out the username or find out the last name just practice them for now I will try to make the next video tomorrow or maybe as soon as possible thank you

Channel: Electrical & Computer Engineering Project

Views: 384,421

Keywords: mysql tutorial for beginners, how to create table in xampp?, phpmyadmin, create database, how to oper phpmyadmin in xampp?, how to start xampp control panel?, how can i insert record in database in phpmyadmin using xampp?, mysql tutorial, mysql beginners tutorial, beginners mysql, mysql, databases, creating a database, adding tables to a database, reading from a database, updating a database, mysql scripts setup, mysql database tutorial, sql server, mysql database

Id: WmFHreVid-k

Length: 10min 31sec (631 seconds)

Published: Thu Nov 01 2018