D3Pipes and more - database reduction by entry size
- You cannot open a new topic into this forum
- Guests cannot post into this forum
msg# 1
GIJOE,
I've looked around and can't find a simple answer to this problem:
I want to cull a d3pipe database of all entries that are smaller than x (say 1k).
I have myphpadmin and was trying to use SELECT, (or even sort for that matter - but it won't sort that way), by the data row/field (DATA) size. That way I could select and delete all entries that were very small in size.
Some data feeds haves items that are very small, especially those regarding dates and figures being updated. So, I have hundreds of very small entries that I'd like to clear out that the clipping (delete by date) function can't do.
If you have time, could you possibly post a mysql SELECT Query that would search that data field and return entries smaller than say 1k in characters (or bytes or something)??
As for making this a feature in D3Pipes, I don't know how many others could use this functionality within the clippings utility tab, but some I'm sure...
Much thanks.
n
Votes:18
Average:8.89
msg# 1.1
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