Stories of daily programming
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)” »
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” »
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…
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…