Check table type MySQL

One way to check the database engine used for a particular table in mysql is to do this SQL command:

SHOW CREATE TABLE my_sample_table

Note: there is probably a better way to figure out if you are using innodb or myisam or whatever, but this works well enough.
 

Didn't work? - ALSO: SHOW TABLE STATUS WHERE Name = 'xxx'

Change table to InnoDB - "ALTER TABLE name ENGINE=INNODB";

 

 

tags: mysql, mysqld

Related Scribbles:
  • Check if innodb enabled mysql
  • Convert to Innodb Tips
  • MySQL Notes


  • ID: 625
    Author:
    leonard
    Date Updated:
    2016-02-20 21:10:44
    Date Created:
    2005-05-20 23:36:20

    Edit

    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> Check table type MySQL
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.