Prisma Update many WHERE with LIMIT?
Got a table full of records that can be assigned to a user, by default they have no user assigned to them. I would like to run something like the following to make sure only X amount of records can be assigned at once.
i cant believe that prisma does not allow this? Im i going mad? https://github.com/prisma/prisma/issues/8359v
UPDATE"verificaiton SET userID = ${userId} WHERE verificaitonSessionId IS NULL LIMIT ${input.limit}i cant believe that prisma does not allow this? Im i going mad? https://github.com/prisma/prisma/issues/8359v
Similar Threads
Was this page helpful?
