MYSQL : Tables

MANAGING TABLES

MySQL Table Types

• ISAM
• MyISAM
• InnoDB
• BerkeleyDB (BDB)
• MERGE
• HEAP

Create Table

CREATE TABLE `tbl_users` (
  `id` int(10) NOT NULL auto_increment,
  `username` varchar(100) default NULL,
  `password` varchar(100) default NULL,
  `firstname` varchar(100) default NULL,
  `lastname` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Showing tables

SHOW TABLES;

Describing tables

DESCRIBE tbl_users;

 Dropping Tables

DROP [TEMPORARY] TABLE [IF EXISTS] tbl_users;

Empty Table's Data

TRUNCATE TABLE tbl_users;