Removing duplicate items in Planetscale
Hey everyone, I am stupid, I forget to implement a unique constraint on one of my db fields. Because of that some users registered multiple times with same value which is supposed to be unique.
Now I can't lose 200 rows of data and I'm running out of time. I need to remove all duplicate items.
I'm using nextjs with trpc and prisma.
Any quick solutions?
1 Reply
Nvm I deleted the db. 200 rows of data is nothing
They can fill it up again
I'm not getting paid
Anyway