SQL:CREATE TABLE bbs_ucenter_applications ( appid smallint(6) unsigned NOT NULL auto_increment, `type` varchar(16) NOT NULL default '', `name` varchar(20) NOT NULL default '', url varchar(255) NOT NULL default '', authkey varchar(255) NOT NULL default '', ip varchar(15) NOT NULL default '', viewprourl varchar(255) NOT NULL, apifilename varchar( 30 ) NOT NULL DEFAULT 'uc.php', charset varchar(8) NOT NULL default '', dbcharset varchar(8) NOT NULL default '', synlogin tinyint(1) NOT NULL default '0', recvnote tinyint(1) DEFAULT '0', extra text NOT NULL, tagtemplates text NOT NULL, allowips text NOT NULL, PRIMARY KEY (appid)) TYPE=MYISAM
Error:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MYISAM' at line 1
Errno:1064
MariaDB [(none)]> select version();
+---------------------+
| version() |
+---------------------+
| 10.0.17-MariaDB-log |
+---------------------+
1 row in set (0.00 sec)
select version(); 方法的时候 显示是这个
这个无法判断是 > 4.1 版本吗?
|