Advanced Search

MySQl table engine

/ Published in: MySQL
Save to your folder(s)
General MySQL engine related commands

Expand | Embed | Plain Text

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.