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.
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/8359v0 Replies