Tab Set Insta
 |
How to use PhpMyAdmin
<!-- @page { margin: 0.79in } P { margin-bottom: 0.08in } A:link { so-language: zxx } -->
We can also write SQL code to do this but At first let's discuss about how to do it with phpMyAdmin so It'll be very useful for everyone. You may download this from www.phpmyadmin.net, unzip it and save it in the "htdocs" directory. Upon insatallation while you first log onto phpMyAdmin the main part of the page has tabs that shows the different options like creating new database, privileges for the database etc.. and these are all will be used to format the database. The left column will show a list of the tables. If we click on one of the tables the main page will show a different set of tabs that format each individual table.
While we can Start with creating the database and once the database is created we'll have only the database but it won't have any data in it. In order to insert data into a database we need to create a "table" within the database. A "table" is simply a section of the database where different categories of data go, and the Query for creating the table is,
CREATE TABLE tname
(
Name Varchar(50) PRIMARY KEY,
Age int(2),
City Varchar(20)
);
But In Phpmyadmin all the Operations are GUI based, So Instaed of typing the query to create a table, just simply type the table name and the number of fields in the corresponding textboxes and click the Go button, fields will be displayed for the data entry. Enter field names and attributes, Click the save button and the table will be created So we have to map out how many fields we'll need before we do this but It provide the option "Edit" so here we can edit the table fields like field name or an attribute. If we want to delete a field, we can do that.
The next option in the operations tab, which will allows us to rename the database is "Rename". If we have an empty database then we can do this but if this database is already being used in the site then we have to rewrite our scripts to point to the new name or that will end up with the errors. The next option will allow us to copy the database to another database. We can copy either only the structure of the database or only the data in the database, or both. We may need to check "Create database before copying" if the database doesn't already exist.
Coming to the "Export" option which will export and download all the data's in the database. So at first, we need to select the tables, which we want to export and then select what format we want them to downloaded in. If we plan on editing that file then export it in CSV for MS Excel or just regular Excel format. Then we need to name the exported file and probably click "Save as file" so that the converted file will be download to our computer.
The above details a simple procedure to install, create and manage a MySQL database using PHPMyAdmin for all your PHP based web applications. Feel free to write to us if you have any questions at..
About the Author