MySQL: Use environment variables in script

Question

Is it possible to make a sql script use a variable defined externally?

E.g. I have the following script:

UPDATE mytable
SET    valid = 0
WHERE  valid = 1

which I have to run through mysql command line several times, each with a different table name.

I would like something like:

SET table_name=foo
mysql -uuser -ppassword < myscript.sql

is it possible?

VoteyDisciple · Accepted Answer · 2011-04-22 13:07:45Z

5

Skirting around the environment variables, why not:

sed 's/mytable/foo/' myscript.sql | mysql -uuser -ppassword

answered Apr 22, 2011 at 13:07

VoteyDisciple

37.9k5 gold badges100 silver badges100 bronze badges

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

1 Comment

Is there a similar program in Windows/DOS?