springboot-plus 导入starter-mysql.sql时出现[Err] 1064 - You have an error in your SQL syntax； check the

墨蓝 2022-12-27 07:59 87阅读 0赞

CREATE TABLE `core_audit` (
      `ID` int(11) NOT NULL AUTO_INCREMENT,
      `FUNCTION_CODE` varchar(45) DEFAULT NULL,
      `FUNCTION_NAME` varchar(45) DEFAULT NULL,
      `USER_ID` int(11) DEFAULT NULL,
      `USER_NAME` varchar(45) DEFAULT NULL,
      `IP` varchar(45) DEFAULT NULL,
      `CREATE_TIME` datetime(6) DEFAULT NULL,
      `SUCCESS` tinyint(4) DEFAULT NULL,
      `MESSAGE` varchar(250),
      `ORG_ID` varchar(45) DEFAULT NULL,
      PRIMARY KEY (`ID`)
    ) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;

*  --------------------
    
    ** 取中间出现错误的一段sql来进行剖析**

> \[Err\] 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 '(6) DEFAULT NULL,  
>   \`SUCCESS\` tinyint(4) DEFAULT NULL,  
>   \`MESSAGE\` varchar(250' at line 8 
> 
> --------------------
> 
>

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70][]

--------------------

**错误出现在第8行，提示语法错误**

--------------------

> **提供个思路，如果确实没有办法的时候，就自己创建个表，看下正确时这个类型在你当前的数据库版本时的正确创建sql**
> 
> --------------------
> 
>

*  **正确时我使用的 datetime 类型的sql**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 1][]

**将需要导入的全局sql内的datatime类型的sql改成如上，尝试运行**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70]: /images/20221120/cb796d1669314ed58fa1bd7af3b6e173.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTcwNjU4_size_16_color_FFFFFF_t_70 1]: /images/20221120/c1971489b4a446c4bbe1a8fe13010b22.png