Mysql keyword in command executed from a shell script

Question

I already know that in order to make Mysql understands a keyword as a column name we should add back ticks.

I am trying to execute this command from a shell script

echo "ALTER TABLE   partners.partners CHANGE COLUMN `name` `client_name` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL" | $MYSQL

Where $MYSQL is my databse connection command (which works fine for other commands).

What I am trying to do is rename the colomn named name to client_name but I have got this error :

 ./test_script.sh: 1: ./test_script.sh: name: not found

If I log to mysql console , execute the same thing , It works perfectly

Any one run into this problem before ?

Try escaping the backticks (IE: \`name\`). I think the backticks are being evaluated as shell commands - unix.stackexchange.com/questions/27428/… — JosephGarrone
– JosephGarrone, Commented Jan 4, 2016 at 10:17

anubhava · Accepted Answer · 2016-01-04 10:18:00Z

2

Use single quotes to avoid interpretation of back-tick or ` which is otherwise used for command substitution:

$MYSQL -e 'ALTER TABLE partners.partners CHANGE COLUMN `name` `client_name` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL'

answered Jan 4, 2016 at 10:18

anubhava

790k67 gold badges603 silver badges671 bronze badges

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

1 Comment

That should've been my first reflex ! It is exactly that