{"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":"2014-12-12T13:00:34","modified_gmt":"2014-12-12T11:00:34","slug":"how-to-comment-a-mysql-table","status":"publish","type":"page","link":"https:\/\/alu.ugr.es\/bioinfo\/?page_id=889","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 FULL COLUMNS FROM db.table;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":5,"comment_status":"closed","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-889","page","type-page","status-publish","hentry"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/alu.ugr.es\/bioinfo\/index.php?rest_route=\/wp\/v2\/pages\/889","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/alu.ugr.es\/bioinfo\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/alu.ugr.es\/bioinfo\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/alu.ugr.es\/bioinfo\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/alu.ugr.es\/bioinfo\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=889"}],"version-history":[{"count":0,"href":"https:\/\/alu.ugr.es\/bioinfo\/index.php?rest_route=\/wp\/v2\/pages\/889\/revisions"}],"wp:attachment":[{"href":"https:\/\/alu.ugr.es\/bioinfo\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}