As part of maintaining the latest software helping security and performance an MySQL upgrade is planned from version 5.1.57 to 5.5.25a. The upgrade will take place over the next few weeks.<\/p>\n\n\n\n
Below is a brief summary of the MySQL changes. The full documentation can be read here:<\/p>\n\n\n\n
http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/upgrading-from-previous-series.html<\/a><\/p>\n\n\n\n It is expected that there will be less than 0.1% of websites will be effected by these changes. Any possible problems are existing issues that will cause an error to occur where before the error was dropped silently.<\/p>\n\n\n\n The following is an overview of potential errors and how they could effect you.<\/p>\n\n\n\n This is the support for display width, any SQL containing \u201cTIMESTAMP(N)\u201d will now cause an error. In previous versions this was silently ignored and then deprecated, this is now a syntax error. Below are 2 examples:<\/p>\n\n\n\n Example on v5.5 (raises error 1064)<\/strong> Example on v5.1 (silently ignored)<\/strong> Any table\/column names and similar (eg functions\/triggers) should always be quoted with backticks (`), this has been the case for many years. If you have a table or column name that matches a reserved word you may get unexpected behavior if not quoted with backticks. It is recommended to check the following page for any new reserved words: http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/reserved-words.html<\/a><\/p>\n\n\n\n The changes here are beyond the scope of this blog entry; you can see the full detailed changes here:Changes to TIMESTAMP<\/h3>\n\n\n\n
mysql> create table `table1` (ts TIMESTAMP);
\nQuery OK, 0 rows affected (0.13 sec)
\nmysql> create table `table2` (ts TIMESTAMP(2));
\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(2))' at line 1<\/code><\/p>\n\n\n\nmysql> create table `table1` (ts TIMESTAMP);
\nQuery OK, 0 rows affected (0.03 sec)
\nmysql> create table `table2` (ts TIMESTAMP(2));
\nQuery OK, 0 rows affected, 1 warning (0.31 sec)
\nmysql> show create table `table2`\\G
\n*************************** 1. row ***************************
\nTable: table2
\nCreate Table: CREATE TABLE `table2` (
\n`ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
\n) ENGINE=MyISAM DEFAULT CHARSET=latin1
\n1 row in set (0.00 sec)<\/code><\/p>\n\n\n\nChanges to reserved words<\/h3>\n\n\n\n
CREATE TABLE IF NOT EXISTS \u2026 SELECT<\/h3>\n\n\n\n
http:\/\/dev.mysql.com\/doc\/refman\/5.5\/en\/create-table-select.html<\/a><\/p>\n\n\n\n\u201cout of range\u201d error (ER_DATA_OUT_OF_RANGE)<\/h3>\n\n\n\n