run mysql command string which is stored in a variable

Question

In Bash I have following code:

alterCmd=alter table $tablename modify $columnname $columntype not null\; | mysql -ulogin -ppw -A $databasename

Normally I do:

echo alter table $tablename modify $columnname $columntype not null\; | mysql -ulogin -ppw -A $databasename

and it works. But I have to build up alterCmd and run it at the end.

How can I run the command that is stored in alterCmd?

Hari Menon · Accepted Answer · 2013-09-13 07:52:40Z

1

alterCmd="alter table $tablename modify $columnname $columntype not null;"
echo "$alterCmd" | mysql -ulogin -ppw -A $databasename

answered Sep 13, 2013 at 7:52

Hari Menon

35.7k15 gold badges90 silver badges111 bronze badges

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

1 Answer 1