The Ultimate Guide to High Availability with MariaDB

Comments - HOW TO CREATE A TABLE WITH ARRAY

3 years, 9 months ago Daniel Black
Re: HOW TO CREATE A TABLE WITH ARRAY

I couldn't find a concrete example of what a vision file is.

SQL doesn't usually use data in arrays. The paradigm is normally a separate table with a common primary key. If you are going to need to search for SKU by color this aspect of normalisation is recommended.

If you are just going to retrieve the 10 colors when selecting the SKU, you could put the 10 colors into a JSON array and have that as the column type.

 
3 years, 9 months ago Alice Tan
Re: HOW TO CREATE A TABLE WITH ARRAY

Hi Daniel,

Thanks for your reply.

In our case, we are going to retrieve the 10 colors when selecting the SKU. May i know that if we are using the JSON array as the column type, the data we still able to use the SQL command to retrieve? Because now we are going to use the SQL for retrieve & manage data.

Can you show me show example on how to use the JSON array?

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.