Create database, table and managing MySQL database using phpMyAdmin

phpMyAdmin is a tool for managing MySQL database and free of charge, it's a web base tool. This tutorial you'll learn how to create database, create table include export(backup) MySQL database.

phpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables, delete/edit/add fields, execute any SQL statement, manage keys on fields, manage privileges,export data into various formats.



If you install Wamp, Xammp or EasyPHP, phpMyAdmin is included in the package. If you manually installed Apache, PHP and MySQL, you can download phpMyAdmin at their officail site. (Click here to download)

phpMyAdmin

phpMyAdmin home

1: Create database using phpMyAdmin

mysql create database 1. To create new database use this form, type database name then click "Create" button. In this example I create database name "test_create_DB".

2: Create table

Create table form
mysql create table

1. After created database. this form'll be display. Enter the name of table and number of field. In this example, I create table name "web_members" for store my web members and it have 4 fields (id, name, lastname, email)



Result after created table on database

3: Create table by runing SQL query

1. You can create table by run SQL query for example, put this code in the form and click "Go"

CREATE TABLE `web_members` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(65) NOT NULL default '',
`lastname` varchar(65) NOT NULL default '',
`email` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

or browse from text file (read export database for creating text file (.sql))

4: Export database

In tab Export. You can export your database in many format like
- SQL (text file .sql)
- Latex
- Microsoft Exel 2000
- Microsoft Word 2000
- CVS for MS Exel
- CVS
- XML

Steps
1. Select table you want to export or select all table.
2. Select file format
3. Select save as file(if you want to save as a file if not select it'll show you only Sql query)
4. Select compression
- None
- zipped (.zip)
- gzipped (.gzip)


Similar Post
Connecting to MySQL database

Connect to MySQL database

This tutorial will show you how to connect to mysql database. It's easy to write a script to connect to world's most popular opensource database.
Select data From mysql

Select data From mysql

When you need data from your mysql database to show in your web page, you need to select database, table and what's row you want to pull its data first.