{"id":889,"date":"2014-12-12T13:00:34","date_gmt":"2014-12-12T11:00:34","guid":{"rendered":"http:\/\/bioinfo2.ugr.es\/ceUGR\/?page_id=889"},"modified":"2018-05-23T17:57:44","modified_gmt":"2018-05-23T15:57:44","slug":"how-to-comment-a-mysql-table","status":"publish","type":"page","link":"https:\/\/bioinfo2.ugr.es\/ceUGR\/how-to-comment-a-mysql-table\/","title":{"rendered":"How to comment a MySQL table"},"content":{"rendered":"<p><span style=\"text-decoration: underline; color: #333333;\"><span style=\"text-decoration: underline;\"><strong>Create a new table with comments:<\/strong><\/span><\/span><\/p>\n<p><span style=\"color: #3366ff;\"><strong>CREATE TABLE db.table(chrom VARCHAR(5) COMMENT &#8216;Chromosome&#8217;, chromStart INT(10) COMMENT &#8216;Zero-based Start Coordinate&#8217;, PRIMARY KEY(chrom,chromStart));<\/strong><\/span><\/p>\n<p><span style=\"text-decoration: underline; color: #333333;\"><strong>Modify columns to add\/change comments:<\/strong><\/span><\/p>\n<p><span style=\"color: #3366ff;\"><strong> ALTER TABLE db.table CHANGE chrom chrom VARCHAR(5) COMMENT &#8216;Chromosome&#8217;;<\/strong><\/span><\/p>\n<p><span style=\"text-decoration: underline; color: #333333;\"><strong>Display information about the columns:<\/strong><\/span><\/p>\n<p><span style=\"color: #3366ff;\"><strong>SHOW FULL COLUMNS FROM db.table;<\/strong><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Create a new table with comments: CREATE TABLE db.table(chrom VARCHAR(5) COMMENT &#8216;Chromosome&#8217;, chromStart INT(10) COMMENT &#8216;Zero-based Start Coordinate&#8217;, PRIMARY KEY(chrom,chromStart)); Modify columns to add\/change comments: ALTER TABLE db.table CHANGE chrom chrom VARCHAR(5) COMMENT &#8216;Chromosome&#8217;; Display information about the columns: SHOW &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/bioinfo2.ugr.es\/ceUGR\/how-to-comment-a-mysql-table\/\"> <span class=\"screen-reader-text\">How to comment a MySQL table<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":5,"comment_status":"closed","ping_status":"open","template":"","meta":[],"_links":{"self":[{"href":"https:\/\/bioinfo2.ugr.es\/ceUGR\/wp-json\/wp\/v2\/pages\/889"}],"collection":[{"href":"https:\/\/bioinfo2.ugr.es\/ceUGR\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bioinfo2.ugr.es\/ceUGR\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/bioinfo2.ugr.es\/ceUGR\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/bioinfo2.ugr.es\/ceUGR\/wp-json\/wp\/v2\/comments?post=889"}],"version-history":[{"count":2,"href":"https:\/\/bioinfo2.ugr.es\/ceUGR\/wp-json\/wp\/v2\/pages\/889\/revisions"}],"predecessor-version":[{"id":892,"href":"https:\/\/bioinfo2.ugr.es\/ceUGR\/wp-json\/wp\/v2\/pages\/889\/revisions\/892"}],"wp:attachment":[{"href":"https:\/\/bioinfo2.ugr.es\/ceUGR\/wp-json\/wp\/v2\/media?parent=889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}