When it’s time for a new MySQL release, it’s also time to thank our contributors ! Released on April 26th, MySQL 8.0.29 contains several contributions from our awesome Community and on behalf of the entire MySQL Team, I would like…
I could have also called this article When Pandas meet Dolphins in MySQL Shell. Some time ago, I wrote a post related on how to collect initial relevant data when trying to seek help for MySQL. Since then, the MySQL…
Recently we saw how we can catch audit information using invisible column, JSON data type and triggers in MySQL 8.0: Poorman’s MySQL table audit information Poorman’s MySQL table audit information – part 2 Of course, the creation of these triggers…
I really enjoyed to dig into the solution I described yesterday in this post, to generate table audit information using invisible columns and triggers. In this post, I will focus only on the solution using a JSON column to store…
Today, somebody asked me how he could track the creation of a record (who created it and when) and who and when it was last modified. Usually, this is performed in a different table, called audit table. In MySQL you…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.