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.
CREATE DATABASE micro;
1 2 3 4
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)