Incompatibilites when upgrading to MySQL 4.1
Cross posting this nice article from Mike Kruckenberg into my PHP section, since it has some great things to keep in mind.
I recently went through this on a platform I was maintaining. The thing that bit me in the ass was some very silly ways previous programmers were parsing timestamp fields. Lesson: do it the right way the first time. The MySQL date/time functions are able to do whatever you need done, there is no need to do date parsing in PHP.
The other issues are mostly minor, and if you do need to change them are relatively easy todo with a global search and replace, or configuration option. Those hours of digging through code looking for timestamp parsing code taught me to RESPECT THE TIMESTAMP!



February 25th, 2007 at 7:09 am
YES,VERY GOOD WEBSITE!
March 19th, 2007 at 12:34 am
It’s a great website of yours. I surfed by and found it very informative. Bookmarked and check you back in a while
June 18th, 2007 at 1:07 pm
washer and dryer review…
shit-happens 2688276 Information source about washer and dryer review….
February 16th, 2008 at 8:54 pm
perfect site !!!!!!!! Perfect piece of work fellows !!!!!!!
February 21st, 2008 at 8:21 pm
Hi everyone A big thank you for this wonderful site, it has helped me immensely