PEAK XOOPS - Re: D3Pipes and more - database reduction by entry size in englishin japanese

Top > XOOPS Modules >d3pipes/xhld >D3Pipes and more - database reduction by entry size

Re: D3Pipes and more - database reduction by entry size

List posts in the topic

none Re: D3Pipes and more - database reduction by entry size

msg# 1.1
depth:
1
Previous post - Next post | Parent - No child | Posted on 2007/12/13 5:44 | Last modified
GIJOE  ÀèǤ·³Áâ   Posts: 4110
Do you want to know how to delete entries smaller than 1k from clipping table?

Then, this SQL will help you.

DELETE FROM (prefix)_(dirname)_clippings WHERE LENGTH(data) < 1024;

Of couser, you'd better query "SELECT" for confirming before "DELETE".

SELECT COUNT(*) FROM (prefix)_(dirname)_clippings WHERE LENGTH(data) < 1024;
Votes:4 Average:10.00

Posts tree

  Advanced search

Login
Username or e-mail:

Password:

Remember Me

Lost Password?

Register now!