Sep
30
2006

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!

Written by Aaron Wormus in: MySQL, PHP |

6 Comments »

  • type

    YES,VERY GOOD WEBSITE!

    Comment | 25/2/2007
  • tabs

    It’s a great website of yours. I surfed by and found it very informative. Bookmarked and check you back in a while

    Comment | 19/3/2007
  • washer and dryer review…

    shit-happens 2688276 Information source about washer and dryer review….

    Trackback | 18/6/2007
  • need unsecured personnal loan

    perfect site !!!!!!!! Perfect piece of work fellows !!!!!!!

    Comment | 16/2/2008
  • bankruptcy personal credit card debt collection

    Hi everyone A big thank you for this wonderful site, it has helped me immensely

    Comment | 21/2/2008
  • visit now

    perfect site !!!!!!!! Perfect piece of work fellows !!!!!!!

    Comment | 19/11/2008

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress | Aeros Theme | TheBuckmaker.com WordPress Themes