Manipulate MySQL8 JSON colums Part 1: simple array

MySQL 8 has introduced an advanced support of JSON type and functions. The documentation is complete for the functions but I found the examples not very helpful and too much theorical. The idea here is to show, with a real, but simplified, database some things we can do with this format. In this first article, we will manipulate a JSON colums containing a simple array. Read the post