Pastebin
API
tools
faq
paste
Login
Sign up
SHARE
TWEET
Slowly clear out old data from a table
fooflington
Aug 21st, 2013
94
0
Never
Add comment
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
MySQL
0.15 KB
| None
|
0
0
raw
download
clone
embed
print
report
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
Public Pastes
Leaked Exploit 5k $
CSS | 14 min ago | 0.76 KB
Big Btc Earnings
CSS | 15 min ago | 0.23 KB
dm.cfg
4 hours ago | 1.00 KB
Untitled
5 hours ago | 8.11 KB
Untitled
PHP | 6 hours ago | 1.35 KB
Untitled
13 hours ago | 1.42 KB
Untitled
13 hours ago | 15.21 KB
Untitled
14 hours ago | 0.01 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!