MySQl table engine


/ Published in: MySQL
Save to your folder(s)

General MySQL engine related commands


Copy this code and paste it in your HTML
  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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.