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!

5 Responses to “Incompatibilites when upgrading to MySQL 4.1”

  1. type Says:

    YES,VERY GOOD WEBSITE!

  2. tabs Says:

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

  3. washer and dryer review Says:

    washer and dryer review…

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

  4. need unsecured personnal loan Says:

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

  5. bankruptcy personal credit card debt collection Says:

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

Leave a Reply