使用"TYPE = InnoDB"；在MySQL中抛出异常 [英] Using "TYPE = InnoDB" in MySQL throws exception

问题描述

当我尝试在MySQL中执行以下SQL时，出现错误:

When I try to execute the following SQL in MySQL, I'm getting error:

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"，则查询工作正常.

But if I remove "TYPE = InnoDB", then the query works fine.

以前，该查询工作正常，即在MySQL 5.0中.但是当我升级到MySQL 5.6时，出现了以上错误.

Previously the query worked fine, ie in MySQL 5.0. But when I upgraded to MySQL 5.6, I'm getting the above error.

任何建议/替代方案... ??

Any Suggestions / Alternatives ... ??

推荐答案

使用ENGINE = Innodb代替TYPE = InnoDB. TYPE已在5.1中删除.

Use ENGINE = Innodb instead of TYPE = InnoDB. TYPE was removed in 5.1.

这篇关于使用"TYPE = InnoDB"；在MySQL中抛出异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！