Ready to grow your querying skills? This post introduces curious newcomers to the WHERE clause in MySQL, showing how simple conditions, clever operators, and cheerful library metaphors can help you filter data like a pro. Find the exact records you need using approachable SQL examples—no dusty catalogs required!

We’re introducing a powerful set of enhancements aimed at boosting service availability and manageability thereby simplifying migrations from AWS Aurora, RDS, or MySQL on EC2, and improving performance.

This blog post shows the performance evaluation of the BLOB_INLINE_SIZE column option for NDB tables in comparison without it, as well as the benefits of batching BLOB read and writes.

Curious about what's inside your MySQL tables? This post introduces beginners to the SELECT statement, using friendly library metaphors, approachable SQL examples, and helpful tips—including how to alias column names. Get ready to start exploring your data with confidence!

Having explored the innovative MySQL HeatWave technology that converts Natural Language into SQL (Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave), our next article in this series, dives into a practical use case demonstrating how an AI DBA Assistant can significantly simplify your query generation workflow. In MySQL, there are 3 specialized […]

The post Let Your AI DBA Assistant Write Your MySQL Queries first appeared on dasini.net - Diary of a MySQL expert.

This blog gives you a complete overview of MySQL HeatWave sessions so you can plan your agenda, mark your calendar, and make the most of the event.

Learn how to responsibly update or delete your MySQL data—including the concept of soft deletes—using engaging library metaphors and practical SQL examples. This post guides beginners through UPDATE and DELETE statements, safety tips, and real-world scenarios.

Natural Language to SQL in MySQL HeatWave makes data accessible to everyone, not just SQL experts. By turning plain English into optimized queries, it removes barriers and speeds up insights. While best practices help ensure accuracy, the feature already shows how LLMs are transforming the way we work with data. With the NL_SQL routine, asking your database questions is as simple as asking a colleague.

The post Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave first appeared on dasini.net - Diary of a MySQL expert.

Learn how to bring life to your database by inserting records into your MySQL tables! This post shows beginners how to use INSERT statements—with lighthearted library metaphors, approachable SQL examples, and helpful tips for common pitfalls. A perfect next step on your MySQL journey.

We’ve mentioned this a few times here on the blog already, but in case you missed it, MySQL 8.0’s end-of-life date is April 2026. This probably sounds forever away, but it’s going to sneak up before you know it. Maybe you’ve been putting off thinking about it, or maybe you’re already weighing your options but […]