Chagrin

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.

Syndicate content

Twitter

  • @captain_science so glad you lliked them, especially the bow tie- it was a bit of a crap shoot! 3 years 32 weeks ago
  • Not sure we had enough pie http://flic.kr/p/8WnSf2 3 years 34 weeks ago
  • What part of "don't discuss politics in the lodge" is so &@$!?ing hard to understand? 3 years 36 weeks ago
  • photo.jpg http://flic.kr/p/8Hy5pe 3 years 41 weeks ago
  • It's about time http://flic.kr/p/8GcTJo 3 years 42 weeks ago

Older

Contact

Andy Chase
(978) 297-6402
andychase [at] gmail.com
GPG/PGP Public Key