Skip to content

Error 1064 when creating database #47

@legabgob

Description

@legabgob

Hi, I'm using MySQL 9.5.0 for macos (installed with homebrew) and when running the following:

git clone https://github.com/datacharmer/test_db
cd test_db
mysql -u root -p -t < employees.sql

I get the following output:

+-----------------------------+
| INFO                        |
+-----------------------------+
| CREATING DATABASE STRUCTURE |
+-----------------------------+
+------------------------+
| INFO                   |
+------------------------+
| storage engine: InnoDB |
+------------------------+
+---------------------+
| INFO                |
+---------------------+
| LOADING departments |
+---------------------+
ERROR 1064 (42000) at line 113: 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 'source load_departments.dump' at line 1

I am very much a newbie as this is my first time with SQL. Am i missing a step ? Root user has been created and has all necessary privileges listed in README.md. Thanks for your help !

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions