habr

Индексирование JSON в MySQL

В середине 2015 года, в MySQL 5.7.8 появился тип данных JSON. С тех пор он применяется, чтобы избегать жёстких определений столбцов и сохранять ...
Hacker

Unlocking the Power of JSON in MySQL: Tips and Tricks

JSON data type was first introduced in MySQL 5.7.8 in August 2015. It was quite a while ago, but I still see many people using the TEXT data type to store JSON data. In this article, I will explain ...
Hacker

The Secret to Faster JSON Queries in MySQL: Generated Columns

Your browser does not support the audio element. Ran into a situation where I had a table with loads and loads of records that included a meta JSON column, ideally ...
linuxiac

MySQL 9.0 Released: What’s New, Changed, and Removed

One of MySQL 9.0’s headline features is the advanced handling of JSON data. Users can now save JSON output from EXPLAIN ANALYZE commands directly into a user variable. This feature, available under ...
GitHub

README.md

Description: Learn how to use MySQL JSON_REMOVE() to delete keys, nested fields, and array elements from JSON documents stored in MySQL columns. JSON_REMOVE() deletes one or more elements from a JSON ...
GitHub

Ejemplos-Procedure-Oracle-Mysql-SqlServer-PostgreSql

Múltiples ejemplos de procedure o funciones, usando funciones propias de cada motor y la utilización de estructuras Pivot, XML y JSON en los motores de datos de Oracle, Mysql, SqlServer y PostgreSql.