MySQL query inside ssh, inside bash, with arguments

Question

I'm writing a small bash script to get a random sample of a database table, connecting through ssh.

ssh $SERVER 'mysql -e "SELECT * FROM ${TABLE} WHERE RAND() < ${PROBABILITY} LIMIT ${LIMIT}" -uroot -p ${DATABASE} > temp_dump_file.sql'

I can't get the arguments to be interpreted. The error is:

 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE RAND() <  LIMIT' at line 1

Thanks in advance :)

pgl · Accepted Answer · 2014-01-21 09:19:31Z

1

As noted by @l0b0, the reason it's failing is because you're using single quotes, so ${TABLE} etc won't be expanded properly. Try swapping your use of quotes:

ssh $SERVER "mysql -e 'SELECT * FROM ${TABLE} WHERE RAND() < ${PROBABILITY} LIMIT ${LIMIT}' -uroot -p ${DATABASE} > temp_dump_file.sql"

answered Jan 21, 2014 at 9:19

pgl

8,1512 gold badges26 silver badges31 bronze badges

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

Comments

l0b0 · Accepted Answer · 2014-01-20 22:31:12Z

1

Bash won't expand variables inside single quotes.

edited Jan 20, 2014 at 22:31

answered Jan 20, 2014 at 22:17

l0b0

59.6k32 gold badges155 silver badges247 bronze badges

Collectives™ on Stack Overflow

MySQL query inside ssh, inside bash, with arguments

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related