0

I'm new to mysql. i'm trying to install employees sample database

I tried few as mentioned in stackoverflow but it didn't help

can any one please tell me how to solve this

SELECT 'LOADING departments' as 'INFO';
source load_departments.dump ;
SELECT 'LOADING employees' as 'INFO';
source load_employees.dump ;
SELECT 'LOADING dept_emp' as 'INFO';
source load_dept_emp.dump ;
SELECT 'LOADING dept_manager' as 'INFO';
source load_dept_manager.dump ;
SELECT 'LOADING titles' as 'INFO';
source load_titles.dump ;
SELECT 'LOADING salaries' as 'INFO';
source load_salaries1.dump ;
source load_salaries2.dump ;
source load_salaries3.dump ;

source show_elapsed.sql ;
2
  • source load_departments.sql Try saving files as .sql Commented Jul 29, 2019 at 10:48
  • no it didn't work @ascii_walker Commented Jul 29, 2019 at 10:54

1 Answer 1

3

The source keyword is only supported by the command line client, not MySQL Workbench (it's not a MySQL keyword). Instead load the files mentioned in the source commands manually into MySQL Workbench and run them there.

Alternatively, you can use the command line client as described by the readme of the employees test data github project (https://github.com/datacharmer/test_db):

mysql < employees.sql
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.