{"id":301,"date":"2014-10-01T15:18:56","date_gmt":"2014-10-01T20:18:56","guid":{"rendered":"http:\/\/thenoyes.com\/littlenoise\/?p=301"},"modified":"2014-10-01T15:18:56","modified_gmt":"2014-10-01T20:18:56","slug":"ambiguous-column-names-not-that-kind","status":"publish","type":"post","link":"https:\/\/thenoyes.com\/littlenoise\/?p=301","title":{"rendered":"Ambiguous column names (not that kind)"},"content":{"rendered":"

Time for another quiz to impress your friends, if you have that kind of friends.<\/p>\n

The manual page in question<\/a><\/p>\n

mysql --skip-enable-disable-column-names=0 -e \"select 1\"
\nmysql --skip-disable-enable-column-names=0 -e \"select 1\"
\nmysql --loose-disable-enable-skip-column-names=0 -e \"select 1\"<\/code><\/p>\n

What’s the result? An error about unknown options? A warning? Column headers enabled? Disabled?<\/p>\n


\nmysql --skip-enable-disable-column-names=0 -e \"select 1\"
\n+---+
\n| 1 |
\n+---+
\n| 1 |
\n+---+<\/p>\n

mysql --skip-disable-enable-column-names=0 -e \"select 1\"
\n+---+
\n| 1 |
\n+---+<\/p>\n

mysql --loose-disable-enable-skip-column-names=0 -e \"select 1\"
\nmysql: option '--skip-column-names' cannot take an argument<\/code><\/spoiler><\/p>\n","protected":false},"excerpt":{"rendered":"

Time for another quiz to impress your friends, if you have that kind of friends. The manual page in question mysql –skip-enable-disable-column-names=0 -e “select 1” mysql –skip-disable-enable-column-names=0 -e “select 1” mysql –loose-disable-enable-skip-column-names=0 -e “select 1” What’s the result? An error about unknown options? A warning? Column headers enabled? Disabled? mysql –skip-enable-disable-column-names=0 -e “select 1” +—+ […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[6],"tags":[],"class_list":["post-301","post","type-post","status-publish","format-standard","hentry","category-gotchas"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p2IBF1-4R","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts\/301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=301"}],"version-history":[{"count":4,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions"}],"predecessor-version":[{"id":305,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=\/wp\/v2\/posts\/301\/revisions\/305"}],"wp:attachment":[{"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thenoyes.com\/littlenoise\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}