MySQL Update to 5.5
We are proud to announce that we are in the process of upgrading MySQL from version 5.1.57 to 5.5.25a on our shared servers, continuing our efforts to provide the most up to date software for all users, ensuring the highest levels of website performance and online security.
We’ll give you a brief overview of the changes to MySQL below, but for a more comprehensive look at the changes you can visit the official MqSQL dev page here.
For anyone concerned about the update it’s worth noting that we don’t expect any significant impact on our customers, with around 0.05% of our hosted sites being in any way affected by the change. If you do experience any issues, feel free to get in touch with our customer support team who will be more than happy to help.
Here is a brief summary of the changes covered by the upgrade – for more information on any of what’s below please refer to the official MySQL website or get in touch with Pixel Internet technical support.
Nested Select Statement
Nested select statements will no longer be supported with the syntax SELECT … INTO.
Aliases In DELETE Statements
In DELETE some syntax has been omitted when using aliases – if you have any DELETE statements that utilise table aliases you should check them any ensure they’re up to date.
Any SQL that contains ‘TIMESTAMP(N)’ will now result in an error, unlike previous MySQL versions.
RESERVED WORDS CHANGES
Any column or table named should now always be quoted by backticks – although this has been the case with previous versions, any column/table name that matches a reserved word will now cause an error if not quoted with backticks.