Difference between revisions of "Mysql"

From KeegansWiki
Jump to navigation Jump to search
(Created page with '=InnoDB= ==Won't start== * Delete ib_logfile* logs, restart =Info= ==Create a simple InnoDB table== * ''CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;'' ==…')
(No difference)

Revision as of 05:53, 9 June 2011

InnoDB

Won't start

  • Delete ib_logfile* logs, restart

Info

Create a simple InnoDB table

  • CREATE TABLE customers (a INT, b CHAR (20), INDEX (a)) ENGINE=InnoDB;

InnoDB Status

  • show engine innodb status\G;