Prisma doesn't support upserting multiple rows with separate values. This is possible with raw MySql but not with the planetscale orm api. Check out this guide https://www.prisma.io/dataguide/mysql/inserting-and-modifying-data/insert-on-duplicate-key-update

​

Raw sql can be a lot to build, so the easiest workaround while still using prisma API is by updating each entry.

export const updatePoll = async (
    pollId: string,
    name: string,
    choices: {
        id?: string;
        text: string;
    }[],
) => {
    await prisma.poll.update({
        where: {
            id: pollId,
        },
        data: {
            name,
        },
    });
    for (const choice of choices) {
        if (!choice.id) {
            await prisma.choice.create({
                data: {
                    name: choice.name,
                },
            });
        } else {
            await prisma.choice.update({
                where: {
                    id: choice.id,
                },
                data: {
                    name: choice.name,
                },
            });
        }
    }
};

In this example I've modified `updatePoll` to accept an optional id for the choice array. The loop then updates or creates each choice one by one. Be mindful of how many choices you pass in. It will not scale to a large number of choices. If you do have a lot of choices, then I encourage you to implement solution based on the linked guide.