2011/01/26

InnoDB 지원 여부 확인하기 및 생성하기

mysql> show variables like 'have_innodb';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb | YES |
+---------------+-------+
1 row in set (0.00 sec)

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

Original Post : http://neodreamer-dev.tistory.com/494

No comments :

Post a Comment