update table mariadb from bash script

Question

Trying to write an table update statement in my bash script but gives me a syntax error mysql Ver 15.1 Distrib 5.5.68-MariaDB, for Linux (x86_64) using readline 5.1

mysql -u UserName --password=MyPassword -D MyDatabase -e 'UPDATE MyTable SET name = SomeName WHERE number = someNumber ;'

ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SomeName WHERE number = someNumber' at line 1

Does this work when using mariaDB directly? try put '' around 'SomeName' — Vlad L
– Vlad L, Commented Nov 30, 2020 at 0:18
@VladL you spotted it right away! I posted the answer below. — dwt.bar
– dwt.bar, Commented Nov 30, 2020 at 0:37

dwt.bar · Accepted Answer · 2020-11-30 00:38:00Z

1

So the answer is: you must escape "" like so \" one liner to update mysql db from shell:

mysql -u userName --password=yourPassword -D databaseName -e "UPDATE tableName SET columnName = \"${variable}\" WHERE numberColumn = \"${numberVariable}\""

edited Nov 30, 2020 at 0:38

answered Nov 30, 2020 at 0:21

dwt.bar

497 bronze badges

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

4 Comments

Vlad L Over a year ago

Sorry, I put two single quotes together, so it looks like a double quote. Please use single quotes in MySQL queries.

Vlad L Over a year ago

stackoverflow.com/questions/11321491/…

dwt.bar Over a year ago

@VladL normally yes, but this is bash script so if you put single quotes over ${variable} it will be treated like a string, my version worked for me. reference for single quotes in bash: howtogeek.com/howto/29980/…

markp-fuso Over a year ago

hmmm, the outer double-quotes should be sufficient to allow variable expansion (for variables referenced between the double-quotes) while also allowing for single quotes around the SQL strings, eg, "UPDATE ..... columnName = '${variable}' WHERE numberColumn = '${numberVariable}'" .. or does mariadb require double-quotes around literal values?

Collectives™ on Stack Overflow

update table mariadb from bash script

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related