Created
March 24, 2011 03:20
-
-
Save donpdonp/884495 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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