Tag Archives: mariadb

Silly but This Is a WordPress Blog Running on Kubernetes

You probably think it’s an overkill to use Kubernetes for a WordPress blog with less than a thousand monthly visitors. While this may be true, it’s totally worth using Kubernetes for the bragging rights. This is a WordPress blog running on Kubernetes!

Kubernetes running WordPress and MariaDB
Sources: https://pixabay.com/images/id-5718352/ and https://www.freepik.com/free-vector/cargo-freight-container_3795063.htm
Continue reading Silly but This Is a WordPress Blog Running on Kubernetes

Expert Update Statements with Joins on MariaDB

You can use UPDATE statement in Structured Query Language (SQL) to modify values in the matching rows. However, only some people know that you can use JOINs in UPDATE queries. For example, by using JOINs we can retrieve additional data from other tables or exclude some rows from our update. Soon you will learn how to write update statements with joins on MariaDB / MySQL.

Update statement with multiple joins shown in a database manager
Continue reading Expert Update Statements with Joins on MariaDB

ISO-3166 Country List for MySQL

Country tables are useful when you need a select box containing the countries in your application. It is a must have when you have multiple rows with country fields. ISO-3166 is the standard for 2-letter country codes so this post will show how to import ISO-3166 Country List for MySQL.

I showed every way possible to import the table. Hopefully everyone can benefit from this post.

phpMyAdmin screenshot of ISO-3166 Country List for MySQL
Continue reading ISO-3166 Country List for MySQL