Posted By

sukantahazra on 02/22/10


Tagged

mysql table engine


Versions (?)

MySQl table engine


 / Published in: MySQL
 

General MySQL engine related commands

  1. SHOW engines; # to get supported engines
  2.  
  3. SHOW table status WHERE name = 'tablename'; # to get the table status
  4.  
  5. ALTER TABLE tablename engine = enginename ; # to set to MyISAM or InnoDB, etc.

Report this snippet  

You need to login to post a comment.