Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE PROCEDURE `db`.`clear_table` (d timestamp)
- BEGIN
- REPEAT
- delete from t where date < d limit 500;
- UNTIL ROW_COUNT() = 0 END REPEAT;
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement