Mysql query execution via ssh

Question

I want to make bash alias to run mysql query via ssh

ssh [email protected]  "mysql wp-theme -e 'DELETE * FROM wp_options where option_name like \'%_transient%\''";

but problem is with part \'%_transient%\' where i tried to escape '

I got error

bash: -c: line 0: unexpected EOF while looking for matching `''
bash: -c: line 1: syntax error: unexpected end of file

Can you try changing the \ to \\ as I think I saw something about these being interpreted twice (once for shell and once for SQL). — Nigel Ren
– Nigel Ren, Commented Jun 12, 2017 at 9:14
Hmm i still got same errors with ssh [email protected] "mysql wp-theme -e 'SELECT * FROM wp_options where option_name like \\'%_transient%\\';'" — Gardelin
– Gardelin, Commented Jun 12, 2017 at 9:21

Gardelin · Accepted Answer · 2017-06-12 09:34:20Z

1

After a while I found the solution

ssh [email protected]  "mysql wp-theme -e 'DELETE FROM \`wp_options\` where \`option_name\` like \"%_transient%\";'"

answered Jun 12, 2017 at 9:34

Gardelin

1,08014 silver badges35 bronze badges

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

1 Answer 1