delete old record after exceeding 1000 records

Question

4.00/5 (1 vote)

See more:

Hello there,
I need to delete the old records of the table when records count exceed the 1000...
can i set the limmit of records in a table...??
is there any way to do it automatically or any query...
thanks....

Posted 7-Sep-11 8:28am

XeeShaN AbbAs

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2011-09-07T08:33:00

I would personally say it is a dangerous thing to do, but I can see why you might want this for a log file or similar. There are two ways to do it:
1) Automatically via an INSERT Trigger (haven't tried it myself, but it should work: Google for "MySQL Triggers" and you should find enough info).
2) By doing your inserts via a stored procedure.

Wendelius · Answer 2 · 2011-09-07T08:35:00

No, you cannot set a limit to a table. If you have some kind of date column in the table (for example insertion date), you can delete records that are older than the 1000. record using a SQL statement.

But why do you want to limit the amount of rows? Is it because of performance reasons or something else?

delete old record after exceeding 1000 records

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0