Skip to content

The Dummy Programmer

Stories of daily programming

  • Home
  • The Dummy Programmer Robot
    • Overview
    • Version history & downloads
    • Tutorials
      • TDP Robot – The basics
      • A simple SQL Server backup solution
      • A simple SQL Server backup solution – A next step
  • My other dummy projects
  • Games
    • Space Y: An Asteroids clone
  • Services
    • What’s my user agent
    • What’s my IP address
  • About
  • Toggle search form

Category: MySql

Configure a PHP development environment in Windows (part 4 of 4)

We have finally come to the end of this series of posts. I believe that in a serious PHP development environment a MySql installation cannot be missing. So today we are going to see how we can install a MySql instance in a Windows environment. Let’s start by downloading the software. You can find the…

Read More “Configure a PHP development environment in Windows (part 4 of 4)” »

MySql

Different ORDER BY behavior between MySql and MariaDB

During the porting of an application from MySql to MariaDB, I found another curious fact: I get a different ORDER BY behaviour between MySql And MariaDB. Look at this query: SELECT DISTINCT Z.ID FROM ( SELECT Field1, Field2, Field3…. FROM Table1 ORD INNER JOIN Table2 OC ON ORD.OrderCopID = OC.ID LEFT JOIN Table3 NEG ON…

Read More “Different ORDER BY behavior between MySql and MariaDB” »

MariaDB

phpMyAdmin: #2014 – Commands out of sync

Hello everyone, another day, another error…. I was migrating a MySql database from one server to a new server. In the new server, calling one of the stored procedures of the database from the phpMyAdmin interface I obtained the following error: #2014 – Commands out of sync; you can’t run this command now Two were…

Read More “phpMyAdmin: #2014 – Commands out of sync” »

MariaDB

Hello world!

I want to start this new blog talking about a problem I faced few days ago, working with a web application developed using PHP and MySql. Using the application users experienced unexplained and random slowdowns in the production environment running on a dedicated server of the italian provider Aruba. The same application with the same database…

Read More “Hello world!” »

MySql

Copyright © 2023 The Dummy Programmer | Privacy Policy | Terms of use |

Powered by PressBook Masonry Dark