{"id":6077,"date":"2024-06-27T12:16:47","date_gmt":"2024-06-27T03:16:47","guid":{"rendered":"https:\/\/taitan916.info\/blog\/?p=6077"},"modified":"2024-04-24T13:54:12","modified_gmt":"2024-04-24T04:54:12","slug":"post-6077","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/6077","title":{"rendered":"MySQL\u3067INSERT\u6642\u306b\u30aa\u30fc\u30c8\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u3067\u306f\u306a\u3044\u30ab\u30e9\u30e0\u306b\u9023\u756a\u3092\u767b\u9332\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"

MySQL\u3067INSERT\u6642\u306b\u30aa\u30fc\u30c8\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u3067\u306f\u306a\u3044\u30ab\u30e9\u30e0\u306b\u9023\u756a\u3092\u767b\u9332\u3057\u305f\u3044\u3002\u307e\u305f\u30c7\u30fc\u30bf\u672a\u767b\u9332\u306e\u969b\u306f\u300cNULL\u300d\u3084\u300c0\u300d\u3067\u306f\u306a\u304f\u300c1\u300d\u3092\u767b\u9332\u3057\u305f\u3044\u3002\u4ee5\u4e0b\u306b\u5bfe\u5fdc\u65b9\u6cd5\u3092\u30e1\u30e2\u3002<\/p>\n

 <\/p>\n

\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u69cb\u9020<\/h2>\n
mysql> SHOW COLUMNS FROM `test_table`;\r\n+-------+--------------+------+-----+---------+----------------+\r\n| Field | Type         | Null | Key | Default | Extra          |\r\n+-------+--------------+------+-----+---------+----------------+\r\n| id    | int          | NO   | PRI | NULL    | auto_increment |\r\n| name  | varchar(255) | NO   |     | NULL    |                |\r\n| order | int          | NO   |     | NULL    |                |\r\n+-------+--------------+------+-----+---------+----------------+<\/pre>\n
order\u30ab\u30e9\u30e0\u306b\u5bfe\u3057\u3066\u9023\u756a\u3092\u767b\u9332\u3057\u305f\u3044\u3002<\/p>\n
 <\/p>\n
\u5bfe\u5fdc\u65b9\u6cd5<\/h2>\n
\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9<\/h3>\n
INSERT INTO `test_table` \r\n    (`order`, `name`) \r\n    SELECT COALESCE(MAX(`order`) + 1, 1), \"\u9234\u6728\" \r\nFROM `test_table`;<\/pre>\n
\u6ce8\u610f\u70b9<\/h3>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u69cb\u9020\u304b\u3089\u3059\u308b\u3068\u300cname\u300d\u2192\u300corder\u300d\u306e\u9806\u3067\u66f8\u304d\u305f\u3044\u3068\u3053\u308d\u3060\u3051\u3069\u3001\u305d\u3046\u3059\u308b\u3068\u30b7\u30f3\u30bf\u30c3\u30af\u30b9\u30a8\u30e9\u30fc(MySQL 1064\u30a8\u30e9\u30fc)\u306b\u306a\u308b\u3002\u305d\u306e\u305f\u3081\u300corder\u300d\u3092\u982d\u306b\u6301\u3063\u3066\u304f\u308b\u3053\u3068\u3002<\/p>\n
 <\/p>\n
\u30ea\u30d5\u30a1\u30ec\u30f3\u30b9<\/h2>\n
COALESCE<\/h3>\n
https:\/\/dev.mysql.com\/doc\/refman\/8.0\/ja\/comparison-operators.html#function_coalesce<\/a><\/p>\n
MAX<\/h3>\n
https:\/\/dev.mysql.com\/doc\/refman\/8.0\/ja\/aggregate-functions.html#function_max<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
MySQL\u3067INSERT\u6642\u306b\u30aa\u30fc\u30c8\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u3067\u306f\u306a\u3044\u30ab\u30e9\u30e0\u306b\u9023\u756a\u3092\u767b\u9332\u3057\u305f\u3044 ... <\/p>\n","protected":false},"author":1,"featured_media":1072,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[5,66],"tags":[],"class_list":["post-6077","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-database"],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/6077","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/comments?post=6077"}],"version-history":[{"count":1,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/6077\/revisions"}],"predecessor-version":[{"id":6078,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/posts\/6077\/revisions\/6078"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media\/1072"}],"wp:attachment":[{"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/media?parent=6077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/categories?post=6077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/taitan916.info\/blog\/wp-json\/wp\/v2\/tags?post=6077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}