How to Work with JSON Data in MySQL
JavaScript Object Notation (JSON) is a popular data-interchange format because it is easy to seriali
JSONDatabase ServerMySQL
SQL
July 15, 2021
By Francis Ndungu
Articles Tagged: MySQL
Install WebERP on Ubuntu 20.04
WebERP is an open-source accounting and business management system written in PHP. You can use it to
WebERPUbuntuMySQL
Linux Guides
July 26, 2021
By Anonymous User
How to Use MySQL Regular Expressions
MySQL provides a powerful way to perform complex text-based searches through the regular expressions
Regular ExpressionsDatabase ServerMySQL
SQL
July 15, 2021
By Francis Ndungu
How to Manage Password Policies in MySQL 8
MySQL is the world s most popular open-source database management system that offers on-demand scala
Password PoliciesDatabase ServerMySQL
SQL
July 15, 2021
By Francis Ndungu
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
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