1

I am moving from Postgres to Mysql (using Prisma as my connector).

This schema used to work:

model Page {
  slug        String  @id
  someValue   String
  ...
  tags        String[]
}

However, mysql doesn't seem to like String[]

Unable to get DMMF from Prisma Client: Error: Schema parsing error: Field "tags" in model "Page" can't be a list. The current connector does not support lists of primitive types.

What am I supposed to do in mysql instead?

Improve this question
3
  • What am I supposed to do in mysql instead? Directly - JSON array. Commented Sep 14, 2022 at 9:02
  • Or just design a properly normalised database structure as you are using an rdbms Commented Sep 14, 2022 at 9:47
  • @Akina could you pls add the json array answer to the "Is there any array data type in MySQL like in PostgreSQL", so the possible answers are captured under one question? Commented Sep 14, 2022 at 9:49
Related questions
2825
How can I import an SQL file using the command line in MySQL?
1433
How can I get a list of user accounts using the command line in MySQL?
802
When to use single quotes, double quotes, and backticks in MySQL
Load 6 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.