syntax error : 'source' (source) is not valid input at this position

Question

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 ;

source load_departments.sql Try saving files as .sql

iamabhaykmr
– iamabhaykmr

2019-07-29 10:48:08 +00:00
Commented Jul 29, 2019 at 10:48 — iamabhaykmr
– iamabhaykmr, Commented Jul 29, 2019 at 10:48
no it didn't work @ascii_walker

Scott
– Scott

2019-07-29 10:54:34 +00:00
Commented Jul 29, 2019 at 10:54 — Scott
– Scott, Commented Jul 29, 2019 at 10:54

Mike Lischke · Accepted Answer · 2019-07-30 08:51:00Z

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

answered Jul 30, 2019 at 8:51

Mike Lischke

54.3k18 gold badges142 silver badges209 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

syntax error : 'source' (source) is not valid input at this position

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related