Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Failed to create table in mysql 5.7 #345

Closed
yidoa opened this issue Jan 10, 2022 · 1 comment
Closed

Failed to create table in mysql 5.7 #345

yidoa opened this issue Jan 10, 2022 · 1 comment

Comments

@yidoa
Copy link

yidoa commented Jan 10, 2022

failed to get tables of database "test-123": getTableStmt("test-123", "a", "BASE TABLE") got 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 '-123.a' at line 1
CREATE TABLE a (
id mediumint(9) DEFAULT NULL,
accountId varchar(64) DEFAULT NULL,
roleId int(11) DEFAULT NULL,
roleName varchar(100) DEFAULT NULL,
icon varchar(128) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ;

@yidoa yidoa added the bug Something isn't working label Jan 10, 2022
@tianzhou tianzhou changed the title mysql5.7 创建表时怎么 报sql有问题呢 Failed to create table in mysql 5.7 Jan 10, 2022
@tianzhou
Copy link
Collaborator

Customer confirmed it's using the chinese version of semicolon;

@tianzhou tianzhou added invalid and removed bug Something isn't working labels Jan 11, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants