For the last year, we have been producing a series of short-form videos titled “MySQL Shorts”. Each video focusses on a specific topic and are typically less than 5 minutes long.\ For our Advent Calendar of Content for 2024, we will be counting down the top 5 MySQL Shorts videos based on views as of […]

MySQL Shorts is a short-format video series dedicated to all things MySQL. This post is one in a series where we will count down the top 5 MySQL Shorts videos based on views.

We recently saw that we can benefit from using JSON documents with MySQL HeatWave cluster in OCI (HeatWave accelerator for MySQL Database Service).

However sometimes the data can’t be loaded to HeatWave Cluster or the query cannot use it.

And this is not always easy to understand why. Let’s get familiar on how to find the info.

Data not loaded in HW Cluster

Let’s see an example with this table (collection):

SQL > show create table listingsAndReviews\G
*************************** 1. row ***************************
       Table: listingsAndReviews
Create Table: CREATE TABLE `listingsAndReviews` (
  `doc` json DEFAULT NULL,
  `_id` char(28) GENERATED ALWAYS AS
 (json_unquote(json_extract(`doc`,_utf8mb4'$._id'))) STORED NOT NULL,
  `_json_schema` json GENERATED ALWAYS AS 
  (_utf8mb4'{"type":"object"}') VIRTUAL,
  PRIMARY KEY (`_id`),
  CONSTRAINT `$val_strict_B70EB65BDDBAB20B0EE5BB7532C9060C422A06F8` …

This is a Q&A with the MySQL Community Team that was published earlier on https://www.odbms.org/

The latest MySQL Shorts video has been released !

WooCommerce block product editor | Escaping output in PHP and Laravel | SQL must go | GitHub and MySQL v8. OpenLampTech is a media and content source for PHP, MySQL, and the LAMP stack.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

Josh Otwell has a passion to grow as a PHP Developer, SQL expert, and technical blogger/writer.

Disclaimer: The majority of examples in this post, are performed in a personal development/learning …

The latest Episode of MySQL Shorts is now available! Check out Episode 49 on the MySQL YouTube Channel to learn how to use Check Constraints in MySQL:  

This interview of two members of the MySQL Community Team, Scott Stroz and Frédéric Descamps (AKA lefred)  was previously published on odbms.org. Q: Can you tell us a little about your background? Fred: I’ve worked in the Open-Source world for over 20 years. First, as a Linux developer and consultant. Then, I opted for the […]

The Oracle ACE Program is a community advocacy program that recognizes and rewards individuals for their expertise, leadership, and contributions to Oracle technologies. Within this program, there exists a specialized category for the MySQL experts and contributors. To become recognized as an Oracle ACE for MySQL, individuals must demonstrate a deep comprehension of MySQL, make […]

Writing comprehensive tests for code that interacts with a database can be a challenge. In this post, we talk about how we can use Testcontainers and JUnit to make it is easier to write tests for Java applications that interact with a MySQL database.