Use MySQL Dual Passwords to Change Credentials without Downtime
Starting from MySQL 8.0.14, you can have dual passwords for users accounts. You can use this featur
PHPWeb ServersMySQL
SQL
February 20, 2021
By Francis Ndungu
Articles in category: SQL
Improve MySQL Data Integrity With Check Constraints
Starting from MySQL 8.0.16 database server and later versions, a CHECK constraint is a feature that
Data IntegrityCheck ConstraintsMySQL
SQL
February 20, 2021
By Francis Ndungu
Use MySQL Union Clause For Reporting
The MySQL UNION statement combines the results of multiple SELECT statements. The clause is useful w
Union ClauseDatabase ManagementMySQL
SQL
February 20, 2021
By Francis Ndungu
Secure MySQL Database with System Roles and Permissions
In MySQL, a role is a group of named privileges that can be assigned to users. When creating a datab
System RolesDatabasesMySQL
SQL
February 10, 2021
By Francis Ndungu
Enforce Referential Integrity in MySQL With Foreign Keys
In MySQL, referential integrity is a concept that maintains the relationship of data across multiple
Referential IntegrityForeign KeysMySQL
SQL
February 10, 2021
By Francis Ndungu
Page MySQL Data with a Limit Clause
Pagination is the process of sub-dividing a large recordset into multiple manageable pages. In MySQL
Database ManagementSQL QueriesMySQL
SQL
February 2, 2021
By Francis Ndungu
Use MySQL Aggregate Functions in Multiple Tables with Subqueries
MySQL aggregate functions are in-built self-contained modules that perform calculations on multiple
Aggregate FunctionsSubqueriesMySQL
SQL
February 2, 2021
By Francis Ndungu
Retrieve MySQL Running Totals With Subqueries, Windowed Functions and User-Defined Variables
In MySQL, a running total is a derived column that computes one or more columns values while contin
Windowed FunctionsSubqueriesMySQL
SQL
December 23, 2020
By Francis Ndungu