What's wrong with this simple MYSQL bash script?

Question

I want to run a single MYSQL command on the CLI, i made a bash file like this:

#! /bin/bash 

mysql --user=uuu --password=ppp DATABASE "UPDATE tickets SET status = 'open' WHERE ID = $1;"

When i do something like:

gabriel$ sh open.sh 123456

I get the full command help description and the script does nothing. I tried the query directly on the DB and works. What am I missing?

Ike Walker · Accepted Answer · 2012-02-28 16:10:40Z

3

You are missing the -e flag.

mysql --user=uuu --password=ppp DATABASE -e "UPDATE tickets SET status = 'open' WHERE ID = $1;"

answered Feb 28, 2012 at 16:10

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges

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

Comments

xdazz · Accepted Answer · 2012-02-28 16:12:52Z

1

You can try:

mysql --user=uuu --password=ppp DATABASE < "UPDATE tickets SET status = 'open' WHERE ID = $1;"

answered Feb 28, 2012 at 16:12

xdazz

161k38 gold badges255 silver badges278 bronze badges