In one of my previous posts, CONTINUE HANDLER in MySQL – One way, with examples, I hinted at a forthcoming piece on the topic of using a CURSOR without a CONTINUE HANDLER. Read on and learn the exact error you should see and more importantly, what it means.
Content
CONTINUE HANDLER in MySQL – One way, with examples.
In this blog post, we will visit an alternate CONTINUE HANDLER declaration I recently learned about while studying CURSOR‘s in MySQL.
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
Weekly Reading for week of 02/02/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…
- SQL Injection Vulnerabilities and How to Prevent Them
- Automatic Decryption of MySQL Binary Logs Using Python
- How to Save a MySQL Query Result to a .CSV File
- Top GUI Tools for PostgreSQL
- Lessons learned scaling PostgreSQL database to 1.2bn records/month
- What the Heck is a Lateral Derived Table
- Seven Must-Dos to Secure MySQL 8.0
- MariaDB Platform X3 in a Single Container
- MySQL Performance Benchmarking: MySQL 5.7 vs MySQL 8.0
- How to Save MySQL Query Output to a File