This might be one of the most basic questions, but I am a bit of a HeidiSQL noob so I hope you'll bear with me. I am running a batch file that needs to do some stuff with a database on a server not on a local machine. I need to change a value in the database before I can do that, so that the site the database uses can tell it's temporarily unavailable. I used to do that with Python, but keeping (and updating) Python just for that one task is just too much of a hassle.
Here's the query I need to run before the batch file does its main task:
UPDATE cursing.version SET Accessible = 1 WHERE version.Accessible = 0 LIMIT 1 ;
and here's the query I need to run after the work is done:
UPDATE cursing.version SET Update = " + time.strftime("%d %B %Y") + ", Accessible = 0 WHERE version.Accessible = 1 LIMIT 1 ;
(the time.strftime thing is Python for writing the current date in the database so the site can display when it was last updated)
So how would I go about this in HeidiSQL using its CLI possibilities?