Set autocommit=0 inside ssh command

Question

I want to run a SSH command using a cron and I want to extent this cron by adding autocommit=0 So that auto commit is disabled.

How can I achieve this?

Command:

mysql dbname -u dbuser -p'password' < /path/to/the/sqlscript/var/sql/stock.sql

Assuming you cannot modify the SQL script? What you need to do is probably concatenate `SET autocommit = 0;` and your script and send the concatenation result to stdin, so this is more of a bash question than a MySQL question. — Mikhail Burshteyn, Sep 18 '18 at 20:53

score 2 · Accepted Answer · answered Sep 18 '18 at 21:22

2

There are many ways to prepend / append a string to a file. A simple way:

(echo "set autocommit=0;"; cat stock.sql; echo "set autocommit=1") | mysql dbname -udbuser -ppassword

answered Sep 18 '18 at 21:22

steffen

1 Answers1