The Ultimate Guide to High Availability with MariaDB

Comments - HOW TO CREATE A TABLE WITH ARRAY

3 years, 4 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.