Introduction to MySQL & phpMyAdmin

mySQL

Its better to understand about mySQL too. mySQL is one of the fastest database management tool. Database is nothing but the collection of information stored in rows and columns where columns represents the kind of information and row represents record which belongs to particular person or object.

Collection of rows are columns are called tables and collection of tables are called as database. There will be relation between the tables and database and programming will be accessing the database and then the program gives neccessary output based on the customization.

So what is the use of Database ?.... it is a good question to ask to learn about the php programming. With the storage of databases you can get the report as you expect. For example, if you have database of 100 employees of an organisation we would able to generate the report of total salary, hra, da, gross, net salary and so with that. Employer can generate the report of how much spent on salary, profit, loss calculations.

I hope you get bored to read the thory about anything. let me take you to the lab. We will learn the tool to manage database, how to create database, tables and so now.

phpMyAdmin

This is open source free tool used to manage the mySQL database, tables and entries. You can also execute the sql queries from any web server. Its very easy to learn and work with phpMyAdmin where the interface is very simple and easy. You would able to manage the mySQL tasks quickly.

1. Make sure that WAMP ( or any one) services started in your system.

2. Open up the explorer and access the localhost by http://localhost
You can see the below screen.

3. Click on phpMyAdmin to access the tool. You can find two panels in the screen. Left panel list out the available database and tables. Right panel displays the different menu options to work with phpMyAdmin tool. Create your database by giving your database name on the given box and then click Create.

4. Once database created you can find the same in the left panel. Now its time to create the table on your database. Find the table name box and the number of fieds box on the right panel. Enter the details and then click create to create the table on your database.

5. You will get the table to allow you to enter the fieds. Select the datatype, size and so in the table. You can give the size of each field based on the requirements. Enter the requested details and then click Go to create the table.

6. Table structure will be shown when you click Go in your previous window. Don't forget to note that you can find the text query above the structure of the table. The query is the exact command to create the table.

7. Select the localhost and the my_db database, you would the available tables list on the right panel. With this panel you can able to change the structure of table, add/modify the column names, insert values to the table, modify values to the table, delete the records in a table, drop table etc.