In this blog post, we will visit an alternate CONTINUE HANDLER declaration I recently learned about while studying CURSOR‘s in MySQL.
Advertisements
MySQL
Exploring Generated Columns in MySQL with examples.
Perhaps you have columns in your table that work together to provide some meaningful results. During table creation, you have the option to CREATE a GENERATED COLUMN in MySQL. What is that? And, what can you use it for? Read on to learn with me and find out…
Weekly Reading for week of 02/16/2019
Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…
- Reduce MySQL Core Dump Size by Excluding the InnoDB Buffer Pool
- Monitoring Your 5.7 InnoDB Cluster Status
- Life of a SQL query
- Migrations in databases with large amount of data
- Bootstrapping the transactional data dictionary
- Debugging MariaDB Galera Cluster SST Problems – A Tale of a Funny Experience
- ClusterControl Tips and Tricks: Running ClusterControl on PHP 7
- How to setup MySQL master-master replication with AWS RDS and an on-premises server
- What’s new in PostgreSQL 11 (Fantastice Read!!!)
- PostgreSQL Deep Dive: How Your Data Model Affects Storage
Example of the RENAME USER command in MySQL
Naming your users and specifying their host does not have to be permanent. However, to implement any changes to those two fields, it is better to use the RENAME USER command as opposed to directly updating MySQL system tables. Read on to learn about this command with me…
Weekly Reading for week of 02/09/2019
Enjoy the weekend with these great open-source SQL blog posts from around the web… At times, a few may be a bit dated, but worth the read, while others are relatively current… Share them along…
- How Roles Have Changed in MySQL 8.0 and How to Use Them (Courtesy of yours truly)
- How to produce meaningful datasets using only SQL (Fantastic Read)
- Support for LATERAL derived tables added to MySQL 8.0.14
- Inspecting the Content of a MySQL Histogram
- MySQL Tutorial – Understanding The Seconds Behind Master Value
- What is LOAD DATA and how does it work
- How long will a 64 bit Transaction-ID last in PostgreSQL?
- UUIDs in MySQL are really not random
- IMPLEMENTING “AS OF”-QUERIES IN POSTGRESQL
- An Overview of the Index Changes in PostgreSQL 11