gpt4 book ai didi

mysql - 同步时 SQL 语法错误 1064

转载 作者:太空宇宙 更新时间:2023-11-03 12:30:59 24 4
gpt4 key购买 nike

我正在使用 MySQL Workbench,我刚刚在我的 MySQL 模型中添加了一个新表。当我尝试与数据库同步时,出现以下错误:

Executing SQL script in server
ERROR: Error 1064: 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 ') )
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci' at line 5

CREATE TABLE IF NOT EXISTS `NAW`.`HTML` (
`ID` INT(11) NOT NULL AUTO_INCREMENT ,
`HTML` LONGTEXT NULL DEFAULT NULL ,
PRIMARY KEY (`ID`) ,
SPATIAL INDEX ()
) ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci

SQL script execution finished: statements: 3 succeeded, 1 failed

如果有人看到哪里出了问题那就太好了!

最佳答案

试试这个。

CREATE  TABLE IF NOT EXISTS `NAW`.`HTML` (   
`ID` INT(11) NOT NULL AUTO_INCREMENT ,
`HTML` LONGTEXT NULL DEFAULT NULL ,
PRIMARY KEY (`ID`) ,
SPATIAL INDEX (`ID`)
) ENGINE = MyISAM
DEFAULT CHARACTER SET = utf8
COLLATE = utf8_general_ci

关于mysql - 同步时 SQL 语法错误 1064,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/15383301/

24 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com