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

Edit unquoted hyphens in Creating... lesson #167

Open
kevinatpenn opened this issue Oct 24, 2023 · 1 comment
Open

Edit unquoted hyphens in Creating... lesson #167

kevinatpenn opened this issue Oct 24, 2023 · 1 comment

Comments

@kevinatpenn
Copy link

How could the content be improved?

In the first demo code chunk, the - in ISSN-L causes an error (Result: near "-": syntax error) when running. Suggest changing to ISSNL or comparable.

Which part of the content does your suggestion apply to?

episodes/09-create.md

@kevinatpenn kevinatpenn changed the title Remove unquoted hyphen in Creating... lesson, first code chunk Edit unquoted hyphens in Creating... lesson Oct 24, 2023
@kevinatpenn
Copy link
Author

kevinatpenn commented Oct 24, 2023

Just noticed the unquoted hyphen issue again in the second-to-last code chunk (UPDATE journals SET ISSN-L = 2076-2615, ISSNs = 2076-2615 WHERE id = 3;). Adding double quotes seems like the better solution here: UPDATE journals SET "ISSN-L" = "2076-2615", ISSNs = "2076-2615" WHERE id = 3;

In case it helps, I'm on Windows 10 (build 19043.2364), running the following as portable:
DB Browser for SQLite Version 3.12.2
Built for x86_64-little_endian-llp64, running on x86_64
Qt Version 5.12.8
SQLCipher Version 4.4.0 community (based on SQLite 3.34.1).

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

1 participant