ENGINE = {BDB | MEMORY | ISAM | INNODB | MERGE | MYISAM} : MyISAM « Engine « SQL / MySQL






  1. SQL / MySQL
  2. Engine
  3. MyISAM

ENGINE = {BDB | MEMORY | ISAM | INNODB | MERGE | MYISAM}

     
mysql>
mysql> CREATE TABLE AuthorBios
    -> (
    ->     AuthID SMALLINT UNSIGNED NOT NULL,
    ->     YearBorn YEAR NOT NULL,
    ->     CityBorn VARCHAR(40) NOT NULL DEFAULT 'Unknown'
    -> )
    -> ENGINE=INNODB;
Query OK, 0 rows affected (0.01 sec)

mysql>
mysql> drop table AuthorBios;
Query OK, 0 rows affected (0.00 sec)








Related examples in the same category

1.MyISAM storage engine supports composite indexes that include an AUTO_INCREMENT column.
2.Change the Type of the Table (MyISAM, InnoDB)
3.Secure backup of a MyISAM database: --lock-all-tables:
4.Change it to the more efficient MyISAM type.
5.MYISAM engine