Hey guys, I was just wondering if it's possible to @map two different Prisma fields to one column in a MySql db

@Esau Kang 👋 I don’t think that’s possible.Could you share your use case for this?

Hey there @Ryan, thanks for the speedy response. I'm adding a new field with a specific name to an existing codebase where the new field will always be the same as the value from another field.

If you’re using Postgres, you can use the

generated

identifier for this to make sure all values are same 🙂

Thanks man, I'll keep that in mind. Cheers 🙂

Something like :

create table "user" (
	"id" serial primary key,
	"userId" int generated always as ("id") stored,
	"profileId" int generated always as ("id") stored
);

Let me know if this works 🙂

I'm using mysql, but I found the relevant generated key. thank you so much for pointing me in the right direction! 🙂