This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

HOW TO CREATE A TABLE WITH ARRAY

Hi,

We are currently migrate from vision file to mariadb. May i know that how to create the table where some of the data is need to be in array?

For example, we have many SKU and each SKU will have 10 color. So the color we want it to be the array, because previously we are create as array. So in mariadb we want to made it as array, so when migration, it can map the data correctly.

Thanks You.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.