A tip for union web designers

This is so geeky, if you’re not caught up with the jargon please don’t read any further.

I’ve been busy creating a database for a new website. The database has a several tables, and in them, a number of fields including things like name, country, union, etc.

No matter what I did, the database was not updating.

Then when I changed the name of the field ‘union’ to ‘tradeunion’ it all worked.

And the reason? The word ‘union’ is a reserved word in My SQL 5.0

I am not making this up. Any web designer building an online database for a union may find themselves stuck, as I was, for days – until realizing this was the case.