当我尝试在MySQL中执行以下SQL时,我收到错误:
SQL:
SQL = "CREATE TABLE Ranges (";
SQL += "ID varchar(20) NOT NULL, ";
SQL += "Descriptions longtext NULL, ";
SQL += "Version_Number int NULL, ";
SQL += "Row_Updated bigint NULL, ";
SQL += "Last_Updated datetime NULL, ";
SQL += "XML longtext NULL, ";
SQL += "PRIMARY KEY (ID)";
SQL += ") " + "TYPE = InnoDB";
错误:
您的SQL语法有错误;检查与您的MySQL服务器版本相对应的手册,以便在“TYPE = InnoDB”附近使用正确的语法
但是如果我删除“TYPE = InnoDB”,则查询工作正常.
以前的查询工作正常,即在MySQL 5.0中.但是当我升级到MySQL 5.6时,我收到上面的错误.
任何建议/替代方案…?