错误提示如下You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
to wwwwa, 你的测试不也一样没有出错ERROR吗? "Warning1287The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2. Please use 'ENGINE=storage_engine' instead" 这只是个提醒! 建议你再贴一下 show create table biaozhun 出来看一下,
show create table biaozhun 完后,如果你还坚持这个观点 "TYPE=MyISAM没有执行" 再说吧。做个实现并不难。
id int(12) NOT NULL auto_increment,
xwtitle varchar(250) default NULL,
filename varchar(30) default NULL,
typ varchar(30) default NULL,
xwly varchar(30) default NULL,
xwdate varchar(30) default NULL,
userfile varchar(30) default NULL,
message text,
tjr varchar(30) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;以上是数据库连接文件 的开头
CREATE TABLE biaozhun (
id int(12) NOT NULL auto_increment,
xwtitle varchar(250) default NULL,
filename varchar(30) default NULL,
typ varchar(30) default NULL,
xwly varchar(30) default NULL,
xwdate varchar(30) default NULL,
userfile varchar(30) default NULL,
message text,
tjr varchar(30) default NULL,
PRIMARY KEY (id)
) engine=MyISAM;
mysql> CREATE TABLE biaozhun (
-> id int(12) NOT NULL auto_increment,
-> xwtitle varchar(250) default NULL,
-> filename varchar(30) default NULL,
-> typ varchar(30) default NULL,
-> xwly varchar(30) default NULL,
-> xwdate varchar(30) default NULL,
-> userfile varchar(30) default NULL,
-> message text,
-> tjr varchar(30) default NULL,
-> PRIMARY KEY (id)
-> ) TYPE=MyISAM;
Query OK, 0 rows affected, 1 warning (0.08 sec)mysql> show warnings;
+---------+------+--------------------------------------------------------------
---------------------------------------------------------------+
| Level | Code | Message
|
+---------+------+--------------------------------------------------------------
---------------------------------------------------------------+
| Warning | 1287 | The syntax 'TYPE=storage_engine' is deprecated and will be re
moved in MySQL 6.0. Please use 'ENGINE=storage_engine' instead |
+---------+------+--------------------------------------------------------------
---------------------------------------------------------------+
1 row in set (0.06 sec)
CREATE TABLE biaozhun (
id int(12) NOT NULL auto_increment,
xwtitle varchar(250) default NULL,
filename varchar(30) default NULL,
typ varchar(30) default NULL,
xwly varchar(30) default NULL,
xwdate varchar(30) default NULL,
userfile varchar(30) default NULL,
message text,
tjr varchar(30) default NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;"Warning 1287 The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2. Please use 'ENGINE=storage_engine' instead"楼上可以测试一下
"Warning1287The syntax 'TYPE=storage_engine' is deprecated and will be removed in MySQL 5.2. Please use 'ENGINE=storage_engine' instead"
这只是个提醒! 建议你再贴一下 show create table biaozhun 出来看一下,
show create table biaozhun 完后,如果你还坚持这个观点 "TYPE=MyISAM没有执行" 再说吧。做个实现并不难。