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 in category:
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
Save Time with PHP Data Object (PDO) Shortcuts
PHP Data Object (PDO) is a library that allows you to write portable code for accessing different da
PDODatabasePHP
PHP
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
Setup Paper on Debian 10
Paper is a high-performance fork of Spigot that aims to fix gameplay and mechanics inconsistencies.
PaperServer SetupDebian
Linux Guides
February 11, 2021
By Anonymous User
Setup Paper on CentOS 7
Paper is a high-performance fork of Spigot that aims to fix gameplay and mechanics inconsistencies.
PaperServer SetupCentOS 7
Linux Guides
February 11, 2021
By Anonymous User