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 MySQL on your Windows machine. You may not want to… Continue Reading
Convert MySQL Insert Ignore to PostgreSQL. Continue Reading
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. Continue Reading
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. Continue Reading
Top n values without using a limit clause or its equivalent Continue Reading
