I like the 5.4 developments, overall. It has useful stuff and is being developed and released a reasonable pace. Good progress. While perusing the MySQL 5.4.4 changelog, one particular change drew my attention, since it’s been (re)appearing since 2006. It’s the removal of the TYPE= keyword which was obsoleted since MySQL 4.1 in favour of [...]
Filed under: Uncategorized by arjen on Friday, July 17, 2009 | Social tagging: ALTER TABLE > CREATE TABLE > ENGINE > mysql > TYPE
9 Comments »
When you write your create table statements, always make sure that you make them non-ambiguous. That way even though other servers might have different configurations, you make sure your table will be created in the same way. Imagine for instance you are developing an application on a development server, nicely storing all the scripts you [...]
Filed under: Good practice / Bad practice by Walter Heck on Wednesday, June 24, 2009 | Social tagging: CREATE TABLE > InnoDB > mysql > NO_ENGINE_SUBSTITUTION > sql_mode
2 Comments »