The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
.
google unix.com




View Single Post in the UNIX and Linux Forums - Click on the Thread or Permalink to View Entire Thread -->
  #1 (permalink)  
Old 12-02-2008
wingchun22 wingchun22 is offline
Registered User
  
 

Join Date: Aug 2008
Posts: 19
how to run cron job to truncate database table

hi

i'm a bit stuck trying to find the correct syntax in order to run a cron job which just truncates all info from a single table in my database

i have a main database - db1
and i have a table in that database - userips

i wish to create a cron job that truncates or removes all the info from the userips table everyday

can anyone help me in the correct syntax in order to create a cron job that runs every day at a certain time point

thanks in advance