Skip to content

Instantly share code, notes, and snippets.

@donpdonp
Created March 24, 2011 03:20
Show Gist options
  • Save donpdonp/884495 to your computer and use it in GitHub Desktop.
Save donpdonp/884495 to your computer and use it in GitHub Desktop.
mysql> create table `test1` ( `id` int(32) );
Query OK, 0 rows affected (0.01 sec)
mysql> create table `test2` ( `id` int(32) ) ENGINE=InnoDB;
ERROR 1005 (HY000): Can't create table './socialigniter/test2.frm' (errno: 135)
mysql> show engines;
+------------+---------+----------------------------------------------------------------+
| Engine | Support | Comment |
+------------+---------+----------------------------------------------------------------+
| MyISAM | DEFAULT | Default engine as of MySQL 3.23 with great performance |
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables |
| InnoDB | YES | Supports transactions, row-level locking, and foreign keys |
| BerkeleyDB | NO | Supports transactions and page-level locking |
| BLACKHOLE | NO | /dev/null storage engine (anything you write to it disappears) |
| EXAMPLE | NO | Example storage engine |
| ARCHIVE | NO | Archive storage engine |
| CSV | NO | CSV storage engine |
| ndbcluster | NO | Clustered, fault-tolerant, memory-based tables |
| FEDERATED | NO | Federated MySQL storage engine |
| MRG_MYISAM | YES | Collection of identical MyISAM tables |
| ISAM | NO | Obsolete storage engine |
+------------+---------+----------------------------------------------------------------+
12 rows in set (0.00 sec)
mysql>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment