Chagrin
23 Jan, 2004
It doesn't happen as often as one might expect, but every now and again I get bitten on the ass by the fact that most of my programming knowledge has been acquired on an as-I-go basis.
Today I spent far longer than necessary wondering why my lovely MySQL concatenation query kept returning NULL.
It wasn't until I did a Google search for MySQL CONCAT returns NULL that I was directed to the MySQL Manual, where I read that CONCAT always returns NULL if any of the referenced fields are NULL
In other words, I should have Read The Fine Manual to begin with.
Popular
Recently Perused
- Comcast cable & Internet down in Winchendon MA, 3rd time this week. Gives one pause re: switching to their phone service. #fb — 4 years 2 weeks ago
- I just became the mayor of Beals Memorial Library on @foursquare! http://4sq.com/bpXyNX — 4 years 2 weeks ago
- I just became the mayor of Winchendon Field Office on @foursquare! http://4sq.com/aUMCCT — 4 years 2 weeks ago
- Hay baled fresh off the field -- we live in an awesome place. http://flic.kr/p/8hZF6t — 4 years 3 weeks ago
- Just picking up hay, honestly! (@ Murdock Dairy Farm) http://4sq.com/b9yjcJ — 4 years 3 weeks ago