How To Create a New Table Using the InnoDB Storage Engine

Q

How To Create a New Table Using the InnoDB Storage Engine? - MySQL FAQs - Storage Engines: MyISAM, InnoDB and BDB

✍: FYIcenter.com

A

InnoDB storage engine was developed by Innobase Oy, which is an Oracle company now. InnoDB is transaction safe, and has been used by a number of large Websites, like Slashdot.org.

InnoDB is not the default storage engine. You need to specify "ENGINE = InnoDB" at the end of the "CREATE TABLE" statement to create new tables with InnoDB storage engine. The tutorial exercise below shows you a good example:

>cd \mysql\bin
>mysql -u dev -piyf fyi

mysql> CREATE TABLE fyi_inno (
  id INTEGER PRIMARY KEY,
  title VARCHAR(80), 
  count INTEGER )
  ENGINE = InnoDB;
Query OK, 0 rows affected (0.17 sec)

mysql> SHOW CREATE TABLE fyi_inno;
  CREATE TABLE `fyi_inno` (
  `id` int(11) NOT NULL,
  `title` varchar(80) default NULL,
  `count` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 
1 row in set (0.02 sec)

mysql> INSERT INTO fyi_inno (id) VALUES(-1);
Query OK, 1 row affected (0.05 sec)

2007-05-10, 4786👍, 0💬