Re: Create or define a collection from a JSON column

[Andrzej Religa]

Hi,

For creating a collection you should use createCollection() method on a selected schema.
In your example it would be:
bd_json.createCollection('tab_vol_json');

You can find more details here:
https://dev.mysql.com/doc/x-devapi-userguide/en/creating-a-collection.html

When you create a table manually like you did, you will have a collection-like behavior
but it is not being recognized as a collection by the X Protocol.

--
Andrzej Religa
MySQL Developer Tools