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.

[Head this way for great MySQL blogging >>>]
Advertisements

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…

[Head this way for great MySQL blogging >>>]

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…

[Head this way for great MySQL blogging >>>]