How to Calculate Age From Date of Birth Using TIMESTAMPDIFF in MySQL
When you re creating an age-sensitive application such as a hospital or an insurance company applica
Database ManagementTIMESTAMPDIFFMySQL
SQL
March 9, 2021
By Francis Ndungu
Articles in category: SQL
Best Practices and Techniques with the MySQL Enum Datatype
In MySQL, you can use the ENUM data type to specify a list of permitted values in a column. For inst
Enum DatatypeDatabase ManagementMySQL
SQL
February 21, 2021
By Francis Ndungu
Using MySQL Magic Numbers with If and Case
When designing applications in MySQL, you ll encounter scenarios that require heavy use of magic num
microfinanceMagic NumbersMySQL
SQL
February 20, 2021
By Francis Ndungu
Cache MySQL Data with the PHP Memcached Library
Memcached is a distributed memory caching system that you can use to speed up your web applications.
MemcachedPHPMySQL
SQL
February 20, 2021
By Francis Ndungu
Using Many to Many SQL Relationships and Intermediate Tables
When working in a complex database, you can use an intermediate table to create a many-to-many(M:N)
SQLMany-To-Many RelationshipsDatabase
SQL
February 20, 2021
By Francis Ndungu
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
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