Mysql Column Tag JSON in MariaDB

Created At: 2024-09-11 09:56:05 Updated At: 2024-09-11 09:56:05

If you're working with a video column in MySQL, and you're using the JSON data type for it. MySQL does indeed support the JSON data type, which allows you to store and query structured JSON data efficiently. MariaDB, while largely compatible with MySQL, handles JSON differently. In MariaDB, JSON is treated as a synonym for LONGTEXT, and doesn't have the same native JSON optimizations as MySQL.

If you're using MariaDB and you need JSON functionality, you would have to manage it as text and use functions like JSON_EXTRACT to handle the data. However, if you want to stick with MySQL’s native JSON type, then you’d need to ensure you’re using a MySQL version that supports it (MySQL 5.7+).

Comment

Add Reviews

Recommended Posts

Latest Posts

Subscribe our newsletter