Mysql from command line: execute sql code and then sql script

Question

I want to execute some "sql code" and then sql script that uses mysql user defined variables that I set in the "sql code".

I try from the command line (bash):

mysql -e "sql code" < script.sql

but only "sql code" gets executed. Is there a neat way to accomplish that?

Dan S · Accepted Answer · 2014-10-21 22:30:04Z

1

Move things around with cat - and pipe.

echo "sql code" | cat - script.sql | mysql

The hyphen - tells cat to pass standard in to standard out and since its the first argument it'll wait until standard is finished before sending script.sql

answered Oct 21, 2014 at 22:30

Dan S

9,2093 gold badges40 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

Mysql from command line: execute sql code and then sql script

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