MySQL

Copy a MySQL table using PHP.

This is a short guide on how to copy a MySQL table using PHP.

MySQL: Extract Year and Month from Date column.

This is a short guide on how to get the year and month from a date column in MySQL.

PHP: List the indexes on a MySQL table using PDO.

This is a PHP tutorial on how to list all of the indexes that have been assigned to a MySQL table.

MySQL: Server sent charset (255) unknown to the client.

This is an issue that occurs because MySQL 8 changed its default charset to utfmb4.

PHP: Get a list of all MySQL databases using PDO.

This is a short tutorial on how to get a list of all MySQL databases using PHP’s PDO object.