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?
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?
