{"id":176,"date":"2021-11-11T10:43:39","date_gmt":"2021-11-11T10:43:39","guid":{"rendered":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/?p=176"},"modified":"2021-11-11T10:45:54","modified_gmt":"2021-11-11T10:45:54","slug":"mysql-commands","status":"publish","type":"post","link":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/2021\/11\/11\/mysql-commands\/","title":{"rendered":"MySQL Commands"},"content":{"rendered":"\n<p>Yleiset komennot:<br><strong>ALTER<\/strong> Alter a database or table<br><strong>BACKUP<\/strong> Back up a table<br><strong>\\c<\/strong>  Cancel input<br><strong>CREATE <\/strong>Create a database<br><strong>DELETE <\/strong>Delete a row from a table<br><strong>DESCRIBE<\/strong> Describe a tables columns<br><strong>DROP<\/strong> Delete a database or table<br><strong>EXIT<\/strong> (Ctrl-C) Exit<br><strong>GRANT<\/strong> Change user privileges<br><strong>HELP<\/strong> (\\h, \\?) Display help<br><strong>INSERT<\/strong> Insert data<br><strong>LOCK<\/strong> Lock table(s)<br><strong>QUIT<\/strong> (\\q) Same as EXIT<\/p>\n\n\n\n<p><strong>RENAME<\/strong> Rename a table<br><strong>SHOW<\/strong> List details about an object<br><strong>SOURCE<\/strong> Execute a file<br><strong>STATUS<\/strong> (\\s) Display the current status<br><strong>TRUNCATE<\/strong> Empty a table<br><strong>UNLOCK<\/strong> Unlock table(s)<br><strong>UPDATE<\/strong> Update an existing record<br><strong>USE<\/strong> Use a database<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yleiset komennot:ALTER Alter a database or tableBACKUP Back up a table\\c Cancel inputCREATE Create a databaseDELETE Delete a row from a tableDESCRIBE Describe a tables columnsDROP Delete a database or tableEXIT (Ctrl-C) ExitGRANT Change user privilegesHELP (\\h, \\?) Display helpINSERT Insert dataLOCK Lock table(s)QUIT (\\q) Same as EXIT RENAME Rename a tableSHOW List details about &hellip; <a href=\"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/2021\/11\/11\/mysql-commands\/\" class=\"more-link\">Continue reading <span class=\"screen-reader-text\">MySQL Commands<\/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\/176"}],"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=176"}],"version-history":[{"count":4,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/176\/revisions"}],"predecessor-version":[{"id":180,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/176\/revisions\/180"}],"wp:attachment":[{"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tietokanta.dy.fi:8243\/mikko\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}