mysql in bash with variable

Question

How can i parse a variable in a mysql update statement in a bash script?

i have this but its not going to work

mysql -h HOST -u USERNAME -pUGUESIT -D DATABASE -bse "DELETE FROM table WHERE Position='" . $4 ."'; DELETE FROM table WHERE Instance='" . $4 . "';"

ofcourse username and pass etc are correct but not for public. The question is how I can use the $4 in the statement...

Thanks in advance!

Ike Walker · Accepted Answer · 2010-11-19 20:07:30Z

5

You should be able to do it like this:

"DELETE FROM table WHERE Position='$4'; DELETE FROM table WHERE Instance='$4';"

answered Nov 19, 2010 at 20:07

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges

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

2 Comments

Nico Laemers Over a year ago

ERROR 1142 (42000) at line 1: DELETE command denied to user 'USER'@'IP' for table 'table' im sure i got the rights becouse without $1 and with like 1 it will delete Instance 1

Nico Laemers Over a year ago

Thnx it works now. found the problem. need to do databasename.table in the query

Collectives™ on Stack Overflow

mysql in bash with variable

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related