Introduction to MySQL | Eklavya Online

Introduction to MySQL


Note: “MySQL” it third party (“sun micro system”)
C:\mysql –u root

Types of Table (Engine)

MyISAM: Foreign key constraint does not support
InnoDB: used to support foreign key constraint
BDB: support for UNIX environment
Heap: it is temporary or virtual table, which is created only in memory not in
hard disk
Merge: it is used, if we want to merge more than one table (it is also temporary
or virtual table)


Create table list ( — , — , — )engine=InnoDB;