Introduction to MySQL | Eklavya Online

Introduction to MySQL

Introduction

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)

Syntax:

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