{"id":678,"date":"2012-12-18T16:43:13","date_gmt":"2012-12-18T15:43:13","guid":{"rendered":"http:\/\/www.ericlee.info\/blog\/?p=678"},"modified":"2012-12-18T16:43:13","modified_gmt":"2012-12-18T15:43:13","slug":"a-tip-for-union-web-designers","status":"publish","type":"post","link":"https:\/\/www.ericlee.info\/blog\/a-tip-for-union-web-designers\/","title":{"rendered":"A tip for union web designers"},"content":{"rendered":"<p>This is so geeky, if you&#8217;re not caught up with the jargon please don&#8217;t read any further.<\/p>\n<p>I&#8217;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.<\/p>\n<p>No matter what I did, the database was not updating.<\/p>\n<p>Then when I changed the name of the field &#8216;union&#8217; to &#8216;tradeunion&#8217; it all worked.<\/p>\n<p>And the reason? The word &#8216;union&#8217; is <a href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.0\/en\/reserved-words.html\">a reserved word in My SQL 5.0<\/a><\/p>\n<p>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 &#8211; until realizing this was the case.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is so geeky, if you&#8217;re not caught up with the jargon please don&#8217;t read any further. I&#8217;ve been busy creating a database for a new website. The database has a several tables, and in&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-678","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.ericlee.info\/blog\/wp-json\/wp\/v2\/posts\/678","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ericlee.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ericlee.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ericlee.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ericlee.info\/blog\/wp-json\/wp\/v2\/comments?post=678"}],"version-history":[{"count":1,"href":"https:\/\/www.ericlee.info\/blog\/wp-json\/wp\/v2\/posts\/678\/revisions"}],"predecessor-version":[{"id":679,"href":"https:\/\/www.ericlee.info\/blog\/wp-json\/wp\/v2\/posts\/678\/revisions\/679"}],"wp:attachment":[{"href":"https:\/\/www.ericlee.info\/blog\/wp-json\/wp\/v2\/media?parent=678"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ericlee.info\/blog\/wp-json\/wp\/v2\/categories?post=678"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ericlee.info\/blog\/wp-json\/wp\/v2\/tags?post=678"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}