Find and Delete Duplicate Rows in MySQL with GROUP BY and HAVING Clauses
Sometimes, you might see more than one copy of the same record appearing in a MySQL database table.
GROUP BYHAVING ClausesMySQL
SQL
February 20, 2021
By Francis Ndungu
Articles Tagged: MySQL
Working with MySQL Restrictive Mode
When some of the MySQL columns in a table are defined with the keyword NOT NULL, you may get an erro
Database ManagementSQL ModesMySQL
SQL
February 20, 2021
By Francis Ndungu
How to Implement MySQL Full-Text Search
A MySQL full-text search index allows you to find matches for a given keyword against character-base
Database ManagementFull-Text SearchMySQL
SQL
February 20, 2021
By Francis Ndungu
Use Custom API Fields with PHP and MySQL on Ubuntu 20.04
Allowing end-users to define custom fields when requesting data from your application programming in
PHPUbuntuMySQL
PHP
February 20, 2021
By Francis Ndungu
Create a JSON REST API with PHP and MySQL On Ubuntu 20.04
An application programming interface (API) is a middleware that allows two applications to talk to e
PHPUbuntuMySQL
PHP
February 20, 2021
By Francis Ndungu
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
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