Advertisement
fooflington

Slowly clear out old data from a table

Aug 21st, 2013
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.15 KB | None | 0 0
  1. CREATE PROCEDURE `db`.`clear_table` (d timestamp)
  2. BEGIN
  3.     REPEAT
  4.         delete from t where date < d limit 500;
  5.     UNTIL ROW_COUNT() = 0 END REPEAT;
  6. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement