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.

Sign up for GitHub

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

Jump to bottom

Exported sql file cannot be run due to wrong escape string #269

Closed
LeoQuote opened this issue May 28, 2019 · 1 comment
Closed

Exported sql file cannot be run due to wrong escape string #269

LeoQuote opened this issue May 28, 2019 · 1 comment
Labels
fixed sql

Comments

@LeoQuote
Copy link

LeoQuote commented May 28, 2019 •
edited
Loading

exported sql file looks like this :

INSERT INTO `Table` ('db_name') VALUES ('archer')

this cannot run in mysql 8.0

INSERT INTO `Table` (`db_name`) VALUES ('archer')

this one is ok. notice the grave accent ` instead of quote ' around db_name

Can I configure the escape string around column names ?

Related: hhyo/Archery#228
@hhurz
Copy link
Owner

hhurz commented May 28, 2019 •
edited
Loading

Currently there is no option to enclose table or column names, but I decided to provide those soon.

Update: Version 1.10.4 released which contains new options sql.tableEnclosure and sql.columnEnclosure

@hhurz hhurz closed this as completed Aug 28, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
fixed sql
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@LeoQuote @hhurz