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?

it would be easy if you use some languages ! – Sourav Apr 22 '11 at 13:02 — Sourav, Apr 22 '11 at 13:02
I was trying to do that in pure mysql/DOS mode... :( – Don Apr 22 '11 at 15:24 — Don, Apr 22 '11 at 15:24

score 5 · Accepted Answer · answered Apr 22 '11 at 13:07

5

Skirting around the environment variables, why not:

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

answered Apr 22 '11 at 13:07

VoteyDisciple

1 Answers1