下面是具体的情境
mysql> create table t2(id int,birthday datetime)engine=innodb;
Query OK, 0 rows affected, 2 warnings (0.06 sec)mysql> show warnings;
+---------+------+--------------------------------------------+
| Level | Code | Message |
+---------+------+--------------------------------------------+
| Warning | 1286 | Unknown table engine 'innodb' |
| Warning | 1266 | Using storage engine MyISAM for table 't2' |
+---------+------+--------------------------------------------+
2 rows in set (0.00 sec)
警告位置的引擎‘innodb’,怎么搞?
我的Mysql 是用的ubutun的Apt-get install 安装的
检查一下SHOW ENGINES
怎么看mysql 的版本.
试试:
my.cnf:
找到[mysqld]
basedir=e:\mysql #MySQL根目录
datadir=e:\mysql\data #MySQL data文件夹位置
default-storage-engine=innodb #默认数据库引擎,支持事务处理 innodb_data_home_dir = e:\\mysql\\data
innodb_log_group_home_dir =e:\\mysql\\data 4.保存my.cnf。
启动服务
mysql> select version();
+---------------------+
| version() |
+---------------------+
| 5.1.41-3ubuntu12.10 |
+---------------------+
1 row in set (0.00 sec)