Change the Type of the Table (MyISAM, InnoDB) : MyISAM « Engine « SQL / MySQL






  1. SQL / MySQL
  2. Engine
  3. MyISAM

Change the Type of the Table (MyISAM, InnoDB)

     


ALTER TABLE tblname ENGINE typename








Related examples in the same category

1.MyISAM storage engine supports composite indexes that include an AUTO_INCREMENT column.
2.Secure backup of a MyISAM database: --lock-all-tables:
3.Change it to the more efficient MyISAM type.
4.ENGINE = {BDB | MEMORY | ISAM | INNODB | MERGE | MYISAM}
5.MYISAM engine