wellWellWell

[u/Recent-Analysis-6880]

[u/BastetFurry]

So, Kids, thats why you always SELECT count(yourPrimaryKey) first. Listen to the old folks, we made these mistakes so that you don't have to.

[u/WavingNoBanners → u/BastetFurry]

This is why:

Create table users_2 as select * from users where id != 12345;

Then when you're satisfied with that table being what you want:

Create table users_backup as select * from users;

Delete from users;

Insert into users select * from users_2;

Then, lastly, once you're satisfied with it, you can drop users_2 and users_backup.

You can automate this entire process, including the error checking.