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…
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…
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…
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.