Re: world_x

[Andrzej Religa]

Hi,

When creating the table for CountryInfo the world_x script mimics what createCollection() methods does underneath.

CREATE TABLE `CountryInfo` (
`doc` json DEFAULT NULL,
`_id` varchar(32) GENERATED ALWAYS AS (json_unquote(json_extract(doc, '$._id'))) STORED PRIMARY KEY
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

If you want to create the collection manually via SQL, you need your table structure to be exactly the same (meaning the same field names and types).
Still the preferred way would be just use createCollection() if possible.

--
Regards,
Andrzej Religa
MySQL Developer Tools