The output of my sql query has multiple columns and contains string values which contains space. I need to write bash script where in i have to read values into variable and then use it further in the script also insert them into another database.
In html file, I need to replace only the first occurrence of:
I’m trying to save multiple columns in bash arrays with one query, but I can’t figure it out.
Now I have 3 SELECTs like this:
I’m trying using shell script, to split mysql query output and save it in variables. My code looks like this:
I’m trying to make a simple stored procedure… After exploring a bit, I discover I can’t make any procedure at all, not even the simplest.
For exemple, running this specific procedure from the documentation:
When I tried running the following command on MySQL from within Terminal:
How can I execute an SQL command through a shell script so that I can make it automated?
I would like to purge my SQL database from all entires older than 1 week, and I’d like to do it nightly. So, I’m going to set up a cron job. How do I query mySQL without having to enter my password manually every time?
I tried many scripts for database backup but I couldn’t make it. I want to backup my database every hour.
I added files to “/etc/cron.hourly/” folder, changed its chmod to 755, but it didn’t run.
At least I write my pseudo code.
I’m currently writing my Main Assignment on my last semester at my study (IT-Engineering with Networking) and currently working with MySQL.