{"id":201,"date":"2021-11-11T12:01:07","date_gmt":"2021-11-11T12:01:07","guid":{"rendered":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/?p=201"},"modified":"2021-11-11T12:01:07","modified_gmt":"2021-11-11T12:01:07","slug":"describe-table-info","status":"publish","type":"post","link":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/2021\/11\/11\/describe-table-info\/","title":{"rendered":"DESCRIBE table info"},"content":{"rendered":"\n<p>The <strong>DESCRIBE<\/strong> command is an invaluable debugging aid when you need to ensure that you have correctly created a MySQL table. You can also use it to remind yourself about a table\u2019s field or column names and the types of data in each one. Let\u2019s look at each of the headings in detail:<\/p>\n\n\n\n<p><em>Field<\/em><br>The name of each field or column within a table<br><em>Type<\/em><br>The type of data being stored in the field<br><em>Null<\/em><br>Whether the field is allowed to contain a value of NULL<br><em>Key<\/em><br>What type of key, if any, has been applied (keys or indexes in MySQL are <em>quick<\/em><br>ways to look up and search for data)<br><em>Default<\/em><br>The default value that will be assigned to the field if no value is specified when a new row is created<br><em>Extra<\/em><br>Additional information, such as whether a field is set to auto-increment<\/p>\n\n\n\n<p>Command is: DESCRIBE classics;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The DESCRIBE command is an invaluable debugging aid when you need to ensure that you have correctly created a MySQL table. You can also use it to remind yourself about a table\u2019s field or column names and the types of data in each one. Let\u2019s look at each of the headings in detail: FieldThe name &hellip; <a href=\"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/2021\/11\/11\/describe-table-info\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">DESCRIBE table info<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/201"}],"collection":[{"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=201"}],"version-history":[{"count":1,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/201\/revisions"}],"predecessor-version":[{"id":202,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/201\/revisions\/202"}],"wp:attachment":[{"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=201"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=201"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=201"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}