![]() |
i want drop attachment from 1 to 999
my vb Version 2.3.0
vb attachment 734.5 MB i want drop attachment from 1 to 999 the fourm complete two years and i wana to delete the attachment of the first year Is there any sql database command to do that ? this command allow me to delete the attachment for a certain period of time |
Yes. Use this query:
[sql]DELETE from `attachment` where attachmentid < 999[/sql] |
ok man
Thank You |
hello
i try this DELETE from `attachment` where attachmentid < 999 but its not work corectly can i find another query ??????????????? |
BACK UP FIRST and try:
[sql] DELETE FROM attachment ORDER BY dateline ASC LIMIT 999; [/sql] Untested but should delete the 999 oldest attachments. |
All times are GMT. The time now is 01:41 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|