I please need some direction for creating a basic bash script to run a sql query against a mysql database for nightly maintenance.
Sample info is displayed below.
DB name: test_db
Table name: test_table
SQL command: delete from test_table where id = 0
The site is hosted on a linux server. We have Plesk that we will use for executing the scheduled task.
Your help is very appreciated!