Database & Table Creation: phpMyAdmin


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:

1
CREATE DATABASE micro;

Table Creation:

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


[youtube https://www.youtube.com/watch?v=LWqkQNHajzs]

YouTube Link: https://www.youtube.com/watch?v=LWqkQNHajzs [Watch the Video In Full Screen.]



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)

Leave a Reply

Your email address will not be published. Required fields are marked *