Dear MySQL Community, As the year comes to a close, we wanted to take a moment to extend our warmest season’s greetings and best wishes to all of you. It has been a remarkable journey working together with such a vibrant and diverse community, and we are grateful for your continuous support and inspiration. As […]

 We are approaching the conclusion of our MySQL Content Advent Calendar 2023. Today, we bring you an immensely popular article that was published earlier this autumn. The article delves into a highly trending subject: the utilization of Kubernetes for running MySQL. Let’s see how to deploy WordPress and MySQL on a Kubernetes Cluster. The Kubernets […]

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 […]