advanced code snippet search

Posted By

sukantahazra on 02/22/10


Tagged

mysql table engine


Versions (?)

MySQl table engine

 / Published in: MySQL
 

General MySQL engine related commands

Expand | Embed | Plain Text 
  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.