开发者

MYSQL command to execute multiple .sql files

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?


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!!


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

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜