MySQL is a database to store the user information MySQL is free and Opensource it is very easy to use,SQl stand for “structure query language.”
What is Database ?
This is one of the hardest topic to define but i will enplane you as easy as possible lets go, imagine an excel sheet on your mind then divide them into rows and columns and give the row a name like a,b,c,d and give the columns 1,2,3,4 then i want you to store “apple” in a1 if you did it then when you need a apple you would go to a1. this is like an array where the data is stores in specific memory and then pointing that memory to access that data.if you understand this then you know what is a database, a database is used to store large amount of data then application or web pages use that database to access that data,a user can store there picture,music in a database a user can also password protect the data in a database.
How to install Mysql ?
To install MySQL Server on a windows here is the process you can choose your platform.
- Download MySQL by visiting here .
- Download the MySQL windows installer.
- after Downloading install it on the computer.
- Locate the directory where MySQL is installed and open it up.
after the above process it would open a console window ,type in password if you have entered any in the installation process.so lets get started to use MySQL first enter the “help” command basically it will print the list of MySQL commands. To see the Databases enter this command “show databases;” remember to put semi-colon at the end of the command or statement because it means the command or statement has ended.after typing this command you will see some databases that are created to use these databases we will use the “use” command and the name of the database(e.g. use test).to see tables inside the database we will use the “show tables;” remember we are using the test database, To see which database are you using use the “status;” command to see the current status of the database.under the current database you can see your current database that you are using.this command also shows which database server are you using which TCP port are you using and many more things.to create a database we will use “create database” command and the name of the database (e.g.”create database hello;”) this will create a hello database to see your database type the “show databases” command,To delete a database we will use the “drop database” command and the name of the database(e.g.”drop database hello“)this will completely remove every thing of the database that you have chosen remember to use this command with caution.to use our database that we have created we will then again use the “use” command.Let’s create a Table if you don’t know what is a table you can think of this way think a folder is a database and the files inside that folder are tables,to create a table we will use the ‘create’ command,(e.g.”create table infor (name varchar(25), address varchar(100), age int, pnumber varchar(12));”)so it will create a fields named info and inside that it will create varchar(variable character) which is 25 character long and it will create another varchar which is 100 character long then int(integer) age and then varchar which is 12 character long.to see your tables that you have created type the “show tables” command it will the show your tables.if you want to see the content of the infor table use the “describe” command and the name of the table(e.g.”describe infor;”)to erase a table we will use the “drop” command and the name of the table(e.g.”drop table infor”).to insert something in to a table for example our name, address etc.. we will use the “insert into” command and the name of the table.(e.g.”insert into infor values (“sik”, ” fake address”, 14, “5555-555-103”); “) remember string would be in quotes.after that we will select every thing using the “select * from” command and the name of the table(e.g.”select * from infor“) it will basically select every thing from infor table that is inside the “hello” database.if you want to see only address not the name and any other fields the we will use “select”command name of the field and the table name (e.g.”select address from infor”)it will echo the address that is stored in infor.to delete something from the table we will use the “delete from” command and table name then we will type “where” and the name of the field which is equal to content in the field.(e.g.”delete from infro where address=” fake address”).then enter this command “select * from infor” to see if the fake address has deleted or not.
End of MySQL Basics.