Bulk alter schema in MySQL.

There are times when you want to alter schema for all tables in the database. For example, let’s say in your project you have multiple databases with multiple tables on each of them. Suppose that you have columns within that table defined as DECIMAL(11,6). What it means is that the column will have 11 digits […]

Posted on April 20th, 2009 under MySQL • 1 Comment

Introduction to merging with SVN

One of the “problem” in using SVN with branches is that you have to figure out which revisions to apply. In most cases, one could not simply take the HEAD version and simply merge that to a branch or TRUNK. On this page, I’ll attempt to explain why we can’t simply merge the HEAD version. […]

Posted on April 3rd, 2009 under General / Algorithm • 2 Comments

Using PHP Variable Variable.

I’ve known the concept of PHP’s variable-variable from when I start working with PHP years ago. I thought it’s a neat feature that I’m not sure what, if any, it is useful for. Just recently, I found that it’s actually useful for me while generating XML using SimpleXML. If you’ve never heard about variable-variable, then […]

Posted on March 27th, 2009 under PHP • No Comments

Mac Yellow Minimize Button Grayed Out

There’s one annoying problems with my Mac laptop. When I’m at work, I connect to external monitor and work on both built-in monitor on my laptop and the external monitor. When I go home I unplug the external monitor, close the lid and let the laptop goes to sleep. Once in a while, when I […]

Posted on March 25th, 2009 under MacOS X • 11 Comments

Getting around MySQL TIMEDIFF() for hours greater than 838

One of the golden rule of programming is to know about the function you are calling. You need to know what parameters it takes and what return values and type it gives back. For the most part, it’s not too hard to find that out. For MySQL, however, I found that it’s not always easy […]

Posted on March 11th, 2009 under MySQL • 12 Comments

Page 5 of 11« First...34567...10...Last »