generated-column

MySQL JSON data type (available since MySQL 5.7.8) lets you store flexible data directly in a SQL column without changing your schema every time. This article walks through practical operations: creating tables, inserting data, querying with JSON_EXTRACT, updating with JSON_SET, and optimizing performance with generated columns — plus real-world experience on when to use it and when to avoid it.