{"id":6539,"date":"2024-10-04T10:59:42","date_gmt":"2024-10-04T01:59:42","guid":{"rendered":"https:\/\/taitan916.info\/blog\/?p=6539"},"modified":"2024-07-01T16:06:21","modified_gmt":"2024-07-01T07:06:21","slug":"post-6539","status":"publish","type":"post","link":"https:\/\/taitan916.info\/blog\/archives\/6539","title":{"rendered":"MySQL\u3067SELECT\u6642\u306b\u6570\u5024\u30923\u6841\u305a\u3064\u306e\u30ab\u30f3\u30de\u533a\u5207\u308a\u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"

MySQL\u3067\u5546\u54c1\u4fa1\u683c\u306e\u3088\u3046\u306a\u6570\u5024\u306e\u5024\u30923\u6841\u305a\u3064\u306e\u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u53d6\u308a\u51fa\u3057\u305f\u3044\u3068\u3044\u3046\u3053\u3068\u304c\u3042\u3063\u305f\u3002\u3044\u3064\u3082\u3067\u3042\u308c\u3070\u666e\u901a\u306b\u6570\u5024\u3068\u3057\u3066\u53d6\u308a\u51fa\u3057\u3001PHP\u306enumber_format\u95a2\u6570\u3067\u30ab\u30f3\u30de\u533a\u5207\u308a\u306b\u3059\u308b\u3093\u3060\u3051\u3069\u3001\u4eca\u56de\u306fMySQL\u306e\u307f\u3067\u5bfe\u5fdc\u3057\u305f\u304b\u3063\u305f\u3002\u4ee5\u4e0b\u306b\u5bfe\u5fdc\u65b9\u6cd5\u3092\u30e1\u30e2\u3002<\/p>\n

 <\/p>\n

\u30c6\u30fc\u30d6\u30eb\u60c5\u5831<\/span><\/h2>\n

\u30c6\u30fc\u30d6\u30eb\u69cb\u9020<\/span><\/h3>\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| price | int          | NO   |     | NULL    |                |\r\n+-------+--------------+------+-----+---------+----------------+<\/pre>\n
\u30c7\u30fc\u30bf\u5185\u5bb9<\/span><\/h3>\n
mysql> SELECT * FROM `test_table`;\r\n+----+---------+---------+\r\n| id | name    | price   |\r\n+----+---------+---------+\r\n|  1 | \u5546\u54c1A   |   10000 |\r\n|  2 | \u5546\u54c1B   | 1000000 |\r\n|  3 | \u5546\u54c1C   |     500 |\r\n+----+---------+---------+<\/pre>\n
 <\/p>\n
\u5bfe\u5fdc\u65b9\u6cd5<\/h2>\n
SQL\u6587<\/h3>\n
SELECT *, FORMAT(`price`, 0) AS format_price \r\nFROM `test_table`;<\/pre>\n
\u51fa\u529b\u7d50\u679c<\/h3>\n
mysql> SELECT *, FORMAT(`price`, 0) AS format_price \r\n    -> FROM `test_table`;\r\n+----+---------+---------+--------------+\r\n| id | name    | price   | format_price |\r\n+----+---------+---------+--------------+\r\n|  1 | \u5546\u54c1A   |   10000 | 10,000       |\r\n|  2 | \u5546\u54c1B   | 1000000 | 1,000,000    |\r\n|  3 | \u5546\u54c1C   |     500 | 500          |\r\n+----+---------+---------+--------------+<\/pre>\n
 <\/p>\n
FORMAT\u95a2\u6570<\/h2>\n
\u4f7f\u3044\u65b9<\/h3>\n