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
Articles Tagged: MySQL
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
Create a Centralized PHP Data Object Class for MySQL
PHP Data Object (PDO) is a database abstraction layer that unifies access to different databases in
Data ObjectsPHPMySQL
PHP
February 3, 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
Install MySQL on Ubuntu
This Quickstart guide explains how to install MySQL on a Vultr Ubuntu cloud server. The guide applie
Web ServersUbuntuMySQL
Linux Guides
December 23, 2020
By Anonymous User
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
Use MySQL Transactions in PHP on Ubuntu 20.04
A MySQL transaction is a group of SQL (Structured Query Language) commands that you execute on your
PHPUbuntuMySQL
PHP
November 13, 2020
By Francis Ndungu