MySQL, PostgreSQL

Convert MySQL INSERT IGNORE to PostgreSQL

This post shows an example of the MySQL INSERT IGNORE statement in the PostgreSQL version. There are good reasons why you should use PostgreSQL at the onset or migrate to

Read More...

Docker, MySQL

docker-compose.yml for MySQL For Local Development

This post provides a another basic docker-compose.yml .This time is to create a MySQL container with initial user accounts.

Read More...

MySQL, Software Development

Mysqldump, Errorcode: 13, and Windows 7

In order to successfully export data from MySQL to some location in the same server host, the server application itself or the user account it runs on must have a write-access to the destination folder.

Read More...

MySQL, Software Development

MySQL Output Format – XML and HTML Data

MySQL Output Format

Read More...

MySQL, Software Development

Top n values without using a limit clause or its equivalent

Top n values without using a limit clause or its equivalent

Read More...

MySQL, Software Development

Truncate MySQL Tables Before DBUnit Loads Data

This post is about truncating all tables in a MySQL database before DbUnit loads data via @DatabaseSetup. Doing it in @Before method does not work. DBUnit loads the data first via @DatabaseSetup before delegating calls to a @Before method.

Read More...

Docker, MySQL, Software Development, WordPress

docker-compose.yml For WordPress And MySQL

To set up WordPress and MySQL in no time and without installing them, here is a useful docker-compose.yml file. If you’re new to WordPress development, you’d probably installed XAMPP and

Read More...