MYSQL command to execute multiple .sql files

Question

I am wanting to write and execute a single mysql .sql file that will execute multiple other .sql files. I am looking for something equivalent to Oracle's:

@script1.sql
@script2.sql
@script3.sql

Does MYSQL have a command?

Jay Dave · Accepted Answer · 2012-08-09 04:58:01Z

11

From bash or any shell, you can run as follows

cat script*.sql | mysql -u root -pYOURPASSWORD  dbname

This would execute all for your sql files for 'dbname'

Cheers!!

answered Aug 9, 2012 at 4:58

Jay Dave

1,8131 gold badge14 silver badges9 bronze badges

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

Comments

zerkms · Accepted Answer · 2011-03-14 04:36:53Z

4

source script1.sql;
source script2.sql;
...

answered Mar 14, 2011 at 4:36

zerkms

256k73 gold badges447 silver badges551 bronze badges

1 Comment

drquiz Over a year ago

I've actually tried that before, but no success. I am getting the error:

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 user.sql' at line 1

. I have a build.sql file that I want to execute from within Eclipse that runs multiple files. Does the command you wrote have to be ran from a mysql prompt?

Collectives™ on Stack Overflow

MYSQL command to execute multiple .sql files

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related