Mysql8.0.20报错DROP TABLE IF EXISTS ‘user‘解决方案

最新推荐文章于 2025-03-26 18:50:40 发布

阿正的梦工坊

最新推荐文章于 2025-03-26 18:50:40 发布

阅读量1.3w

点赞数 5

分类专栏： MySQL

本文链接：https://blog.csdn.net/shizheng_Li/article/details/107103521

版权

MySQL 专栏收录该内容

5 篇文章

订阅专栏

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with 
name 'org.springframework.boot.autoconfigure.jdbc.DataSourceInitializerInvoker': Invocation of 
init method failed; nested exception is 
org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL 
script statement #1 of class path resource [db/schema.sql]: DROP TABLE IF EXISTS 'user'; nested 
exception is java.sql.SQLSyntaxErrorException: 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 ''user'' 
at line 1

这个错误的原因是使用了如下语法

DROP TABLE IF EXISTS 'user';

check the manual that corresponds to your MySQL server version for the right syntax to use near '‘user’( ‘id’ int(11) NOT NULL AUTO_INCREMENT, ‘name’ varchar(255) DEFAULT NULL, ’ at line 1

错误代码

 DROP TABLE IF EXISTS 'user';
--IF object_id('user','U') is not NULL drop table 'user';
CREATE TABLE 'user'(
    'id' int(11) NOT NULL AUTO_INCREMENT,
    'name' varchar(255) DEFAULT NULL,
    'age' int(11) DEFAULT NULL,
    PRIMARY KEY ('id')
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

mysql版本8.0.20

解决方案：去掉引号，包括去掉表名的引号，属性的引号

DROP TABLE IF EXISTS user;
--IF object_id('user','U') is not NULL drop table 'user';
CREATE TABLE user(
    id int(11) NOT NULL AUTO_INCREMENT,
    name varchar(255) DEFAULT NULL,
    age int(11) DEFAULT NULL,
    PRIMARY KEY (id)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

这个bug太隐蔽了，费时费力。