Basic Tutorial to illustrate phpMyAdmin: create database and tables.
This basic tutorial is to introduce you to phpMyAdmin.
In this video tutorial, we are creating a database called micro and a table called soft inside database micro.
Eventhough you use the phpMyAdmin interface to create database and table, it executes queries to handle your UI requests.
Database Creation:
CREATE DATABASE micro;
Table Creation:
CREATE TABLE `micro`.`soft` (
`id` INT( 10 ) NOT NULL ,
`powerpoint` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM ;
Video Tutorial: Database & Table Creation: phpMyAdmin
Inside the table, we take 2 fields and enter the needed details.
We have taken id as integer and another field called powerpoint with varchar(20)