Because of a buggy wordpress plugin I am using, I have to manually run the following query many times during a single day:
It simply drops the contents of the given column name.
So how can I make my server do it automatically every 30 minutes for instance, through PHPMyadmin?
I am not a PHP nor a SQL SAVVY. So please take that into consideration
I am on Hostmonster.com , and they have MySQL client version: 5.1.60 and phpMyAdmin v. 3.4.9
Code:
update table_name set column_name="";
It simply drops the contents of the given column name.
So how can I make my server do it automatically every 30 minutes for instance, through PHPMyadmin?
I am not a PHP nor a SQL SAVVY. So please take that into consideration
I am on Hostmonster.com , and they have MySQL client version: 5.1.60 and phpMyAdmin v. 3.4.9