Return to Snippet

Revision: 24162
at February 22, 2010 12:28 by sukantahazra


Initial Code
show engines;  # to get supported engines

show table status where name = 'tablename';  # to get the table status

alter table tablename engine = enginename ; # to set to MyISAM or InnoDB, etc.

Initial URL


Initial Description
General MySQL engine related commands

Initial Title
MySQl table engine

Initial Tags
mysql, table

Initial Language
MySQL