{"id":227,"date":"2021-11-18T08:14:03","date_gmt":"2021-11-18T08:14:03","guid":{"rendered":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/?p=227"},"modified":"2021-11-18T08:14:03","modified_gmt":"2021-11-18T08:14:03","slug":"removing-a-column","status":"publish","type":"post","link":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/2021\/11\/18\/removing-a-column\/","title":{"rendered":"Removing a column"},"content":{"rendered":"\n<p>Actually, upon reflection, you might decide that the page count column pages isn\u2019t actually all that useful for this particular database, so here\u2019s how to remove that column by using the DROP keyword:<br>ALTER TABLE classics DROP pages;<\/p>\n\n\n\n<p>Remember that <strong>DROP<\/strong> is irreversible. You should always use it with<br>caution, because you could inadvertently delete entire tables (and<br>even databases) with it if you are not careful!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Actually, upon reflection, you might decide that the page count column pages isn\u2019t actually all that useful for this particular database, so here\u2019s how to remove that column by using the DROP keyword:ALTER TABLE classics DROP pages; Remember that DROP is irreversible. You should always use it withcaution, because you could inadvertently delete entire tables &hellip; <a href=\"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/2021\/11\/18\/removing-a-column\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">Removing a column<\/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\/227"}],"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=227"}],"version-history":[{"count":1,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/227\/revisions"}],"predecessor-version":[{"id":228,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/227\/revisions\/228"}],"wp:attachment":[{"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=227"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=227"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=227"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}