Employees DB has no data
I've installed mysql workbench and tried to query the employee dataset but I get a blank result, see screenshot for detail
Hi Evan!
Thanks for reaching out.
It seems that your database is empty. Please, drop the employees database and run again the employees.sql file.
Hope this helps.
Best,
Tsvetelin
Hi, I've tried to drop the employees database and run the employees.sql file again and I get the following:
The error specifies:
| 0 | 20 | 12:19:43 | source load_departments.dump | Error Code: 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 'source load_departments.dump' at line 1 | 0.000 sec |
Please note I have not modified the syntax of the employees.sql file in any way
Hi Evan!
Please, open the file employees.sql and run it. This file contains the tables and it has more than 30 000 lines of code. You opened something else. Thank you.
Hope this helps.
Best,
Tsvetelin
Okay thanks, I found the employees.sql file in the course notes folder in section 8. I dropped the employee schema again and ran the correct employees.sql file and my database is populated as expected. Thanks for the help!