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
  3. show table status where name = 'tablename'; # to get the table status
  5. alter table tablename engine = enginename ; # to set to MyISAM or InnoDB, etc.

Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.