i need little help.. hope some one will spend few min to help me
i have a database oh mysql and i want to run few queries on that database to update records after every 5 minutes.
queries will be (around 50 such queries)
update <tablename> set <columnname> = <new value> where <primarykey column>=<id>
i know it can be done through cron to execute some script.. but i dunno how to write script for execution of such queries.
please someone tell me.