PHP MYSQL Delete certain amount (5) rows

Question

In my DB I will insert a new row when a user referrers someone to my website. When a user earns 5 referral points I want to remove 5 of the inserted rows that were inserted when they referred someone.

So say my db is like this

|id|userID|
|0 |543678|
|1 |543678|
|2 |543678|
|3 |543678|
|4 |543678|
|5 |543678|

there is a total of 6 inserted rows which represent 6 referrals. So how can I remove (delete) only 5 of these rows and keep 1 remaining? (btw I am working with PHP)

Barmar · Accepted Answer · 2017-02-20 14:04:08Z

1

Use a LIMIT clause in the DELETE query:

DELETE FROM yourTable
WHERE userID = 543678
ORDER BY id
LIMIT 5

answered Feb 20, 2017 at 14:04

Barmar

789k57 gold badges555 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

coddding Over a year ago

Thanks! Working great

Collectives™ on Stack Overflow

PHP MYSQL Delete certain amount (5) rows

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related