{"id":512,"date":"2025-04-16T23:04:30","date_gmt":"2025-04-16T14:04:30","guid":{"rendered":"https:\/\/www.lapidem.pw\/wordpress\/?p=512"},"modified":"2025-04-17T08:55:23","modified_gmt":"2025-04-16T23:55:23","slug":"mysql","status":"publish","type":"post","link":"https:\/\/www.lapidem.pw\/wordpress\/?p=512","title":{"rendered":"mysql"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">WordPress\u7528database wp\u306e\u8a2d\u5b9a<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>mysql -u root -p; \nSHOW DATABASES;\nUSE mysql;\nCREATE DATABASE\u00a0wp (\u5fc5\u8981\u306a\u3044\uff1f\u00a0collate utf8mb4_general_ci\uff09;\nCREATE USER\u00a0<em>wp<\/em>;\n\uff08SET PASSWORD FOR <em>wp<\/em>= '<em>password<\/em>';\uff09\nGRANT ALL PRIVILEGES ON\u00a0<em>wp<\/em>.* to\u00a0<em>wp<\/em>@'localhost'\u00a0IDENTIFIE BY '<em>password<\/em>';\n\n(DROP DATABASE <em>wp<\/em>;)\u524a\u9664\u3057\u305f\u3044\u5834\u5408<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">mysql \u57fa\u672c\u6587\u578b<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>SHOW DATABASES\nCREATE DATABASE database\nuse database\nSHOW TABLES\nDESC table\nSELECT * FROM table\nINSERT INTO table VALUES()\nINSERT INTO table (column,..) VLUES(data,..);\n\t \u30c6\u30fc\u30d6\u30eb\u306e\u30b3\u30d4\u30fc\nCREATE TABLE table SELECT * FROM table\nALTER TABLE table ADD column datatype\nALTER TABLE table MODIFY column datatype\nALTER TABLE table CHANGE column column datatype\nALTER TABLE table DROP column;\nCREATE TABLE table (column datatype PRIMARY KEY)\nCREATE TABLE table (column datatype UNIQUE)\nCREATE TABLE table (column INT AUTO_INCREMENT PRIMARY KEY)\nALTER TABLE table AUTO_INCREMENT=integer;\nALTER TABLE table MODIFY column datatype DEFAULT data;\nCREATE INDEX index ON table(column)\nSHOW INDEX FROM table\nDROP INDEX index ON table\n\t\u30c6\u30fc\u30d6\u30eb\u306e\u30b3\u30d4\u30fc\n\tCREATE TABLE table SELECT * FROM table; increment\u3084key\u306f\u30b3\u30d4\u30fc\u3055\u308c\u306a\u3044\u3002\n\tCREATE TABLE table LIKE table; \uff08\u69cb\u9020\u306e\u307f\u30b3\u30d4\u30fc\uff09\u30c7\u30fc\u30bf\u306f\u30b3\u30d4\u30fc\u3055\u308c\u305f\u3044\u3002\u5c5e\u6027\u306f\u30b3\u30d4\u30fc\u3055\u308c\u308b\u3002\n\tINSERT INTO table SELECT * FROM table;\n\t\u30c6\u30fc\u30d6\u30eb\u306e\u524a\u9664\n\tDROP TABLE table;\n\tDELETE FROM table; \uff08\u30c7\u30fc\u30bf\u306e\u307f\u524a\u9664\uff09\nSHOW TABLES like 'mdl_%'\n\t\u30c7\u30fc\u30bf\u306e\u8aad\u307f\u8fbc\u307f\nmysql&gt; LOAD DATA LOCAL INFILE '\/path\/pet.txt' INTO TABLE pet;\n\t\u30c7\u30fc\u30bf\u306e\u5909\u66f4\nmysql&gt; UPDATE pet SET birth = '1989-08-31' WHERE name = 'Bowser';\n\t\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u306e\u524a\u9664\nmysql&gt; DELETE FROM pet;\nDROP DATABASE database; \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u524a\u9664<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>WordPress\u7528database wp\u306e\u8a2d\u5b9a mysql \u57fa\u672c\u6587\u578b<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8,2,37,35],"tags":[],"class_list":["post-512","post","type-post","status-publish","format-standard","hentry","category-debian-linux","category-linux","category-mysql","category-wordpress"],"_links":{"self":[{"href":"https:\/\/www.lapidem.pw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.lapidem.pw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.lapidem.pw\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.lapidem.pw\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.lapidem.pw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=512"}],"version-history":[{"count":6,"href":"https:\/\/www.lapidem.pw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/512\/revisions"}],"predecessor-version":[{"id":547,"href":"https:\/\/www.lapidem.pw\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/512\/revisions\/547"}],"wp:attachment":[{"href":"https:\/\/www.lapidem.pw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.lapidem.pw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=512"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.lapidem.pw\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}