{"id":190,"date":"2021-11-11T11:12:48","date_gmt":"2021-11-11T11:12:48","guid":{"rendered":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/?p=190"},"modified":"2021-11-11T11:12:48","modified_gmt":"2021-11-11T11:12:48","slug":"creating-a-database","status":"publish","type":"post","link":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/2021\/11\/11\/creating-a-database\/","title":{"rendered":"Creating a database"},"content":{"rendered":"\n<p><br>a new database called tietokantadb:<br><strong>CREATE DATABASE tietokantadb;<\/strong><br>A successful command will return a message that doesn\u2019t mean much yet\u2014Query OK,<br>1 row affected (0.00 sec)\u2014but will make sense soon. Now that you\u2019ve created the database, you want to work with it, so issue the following command:<br><strong>USE tietokantadb;<\/strong><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>a new database called tietokantadb:CREATE DATABASE tietokantadb;A successful command will return a message that doesn\u2019t mean much yet\u2014Query OK,1 row affected (0.00 sec)\u2014but will make sense soon. Now that you\u2019ve created the database, you want to work with it, so issue the following command:USE tietokantadb;<\/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\/190"}],"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=190"}],"version-history":[{"count":1,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/190\/revisions"}],"predecessor-version":[{"id":191,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/190\/revisions\/191"}],"wp:attachment":[{"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=190"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=190"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=190"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}