Create An InnoDB Table

• To create an InnoDB table, specify ENGINE = InnoDB option in the CREATE TABLE statement.
  • For example:

    CREATE TABLE players (number INT, name CHAR (24), INDEX (a)) ENGINE=InnoDB;

• To find the amount of free space in the InnoDB tablespace issue a SHOW TABLE STATUS statement.
  • For example:

    SHOW TABLE STATUS FROM test LIKE 'players' ;

How does AUTO_INCREMENT with InnoDB work?

---

---

© 2007 John Michael Pierobon

Notes