I am just starting the “Complete SQL Mastery” course and am running the “create-databases.sql” script as provided in the course.
I am getting the error messages below.
Can anyone please tell me how to go about resolving them?
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near ‘
'. Msg 195, Level 15, State 7, Line 5 'NAMES' is not a recognized SET option. Msg 102, Level 15, State 1, Line 89 Incorrect syntax near '’.
Msg 102, Level 15, State 1, Line 226
Incorrect syntax near ‘`’.
Msg 105, Level 15, State 1, Line 308
Unclosed quotation mark after the character string ',6,1.09);
I had issues with this when I did the course. This is what I posted some time back. Do a search and you can find other solutions.
When I run the create-databases script (Win 10, MySQL Workbench8), some of the databases show “fetching” tables, views etc. If I EXIT MySQL and re-enter, all databases are fine.
I checked the other scripts and two have errors. create-db-store and create-db-invoicing. At the top of the files these scripts drop and create databases “store” and “invoicing”. These should be “sql_store” and “sql_invoicing”.
@kavfam thank you so much. getting out and coming back again worked,