MySQL query remove rows

Question

I know that this is not the perfect question for SO but this question is very important for me:

DELETE FROM `pligg_links` WHERE `link_id` > 10000

Will this query delete all entries in table pligg_links which have link_id's bigger than 10000?

no because it needs to do exactly as indicated above other wise ... — Dum Potato
– Dum Potato, Commented May 18, 2012 at 20:10
@Chriswede Are you trying to test above query on production directly? — Firoz Ansari
– Firoz Ansari, Commented May 18, 2012 at 20:10

Mark Byers · Accepted Answer · 2012-05-18 20:17:47Z

2

If you're not sure then run a SELECT first to see what will be deleted:

SELECT * FROM `pligg_links` WHERE `link_id` > 10000

The rows that are returned by this query are those that will be deleted by changing SELECT * to DELETE.

I would recommend using this technique any time you are writing a DELETE statement to prevent accidents due to typos, and especially so if recovering accidentally deleted data is time consuming.

edited May 18, 2012 at 20:17

answered May 18, 2012 at 20:11

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

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

Comments

Sirko · Accepted Answer · 2012-05-18 20:09:09Z

1

Assuming you got the propper rights, it will.

answered May 18, 2012 at 20:09

Sirko

74.3k19 gold badges157 silver badges194 bronze badges

1 Comment

user1233508 Over a year ago

It will also fire any ON DELETE CASCADE foreign keys and delete triggers that might be defined.

Brian Warshaw · Accepted Answer · 2012-05-18 20:09:43Z

1

If link_id is, indeed, an numerical field, then yes.

answered May 18, 2012 at 20:09

Brian Warshaw

23k9 gold badges55 silver badges72 bronze badges

Comments

Shiin Zu · Accepted Answer · 2012-05-18 20:17:33Z

1

Always try destructive statements on a backup copy of the database before using it on production. That's assuming you have a copy of the database somewhere.

answered May 18, 2012 at 20:17

Shiin Zu

1669 bronze badges

Collectives™ on Stack Overflow

MySQL query remove rows

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related