how do i select last 5 minutes data from table
there is table called 'x' which has cron job set of interval=5 min,i want to select last 5 min data and delete rest of the data in it or save in one of the table say 'y'.how do i going to do it???kindly help out please??
Edited by: user10341747 on Sep 24, 2008 10:20 AM