<\/span><\/h2>\n\n\n\n\u5f53\u6709\u4e24\u4e2a\u6216\u591a\u4e2a\u53c2\u6570\u65f6\uff0c\u8fd4\u56de\u503c\u4e3a\u6700\u5c0f\u7684\u53c2\u6570\u503c\u3002
\u5f53\u53c2\u6570\u4e2d\u6709\u4e00\u4e2a\u4e3a NULL \u65f6\uff0c\u76f4\u63a5\u8fd4\u56de NULL<\/span>\u3002
\u5f53\u53c2\u6570\u90fd\u662f\u5b57\u7b26\u4e32\u65f6\uff0c\u9ed8\u8ba4\u662f\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u7684\uff0c\u5982\u679c\u5e0c\u671b\u8fdb\u884c\u5b57\u7b26\u4e32\u53d6\u503c\u5927\u5c0f\u5199
\u654f\u611f\u7684\u6bd4\u8f83\uff0c\u5219\u5728\u9700\u8981\u654f\u611f\u7684\u5b57\u7b26\u4e32\u53c2\u6570\u524d\u52a0\u4e0a BINARY\u3002
\uf06c \u8fd9\u4e9b\u53c2\u6570\u6bd4\u8f83\u4f7f\u7528\u4e0b\u5217\u89c4\u5219\uff1a
\u2022 \u5982\u679c\u8fd4\u56de\u503c\u5728 INTEGER \u4e0a\u4e0b\u6587\u4e2d\u6216\u8005\u6240\u6709\u7684\u53c2\u6570\u662f\u6574\u578b\u503c\uff0c\u90a3\u4e48\u5b83\u4eec\u4f7f\u7528\u6574\u6570\u6bd4\u8f83\uff1b
\u2022 \u5982\u679c\u8fd4\u56de\u503c\u5728 REAL \u4e0a\u4e0b\u6587\u4e2d\u6216\u8005\u6240\u6709\u7684\u53c2\u6570\u662f\u5b9e\u6570\u503c\uff0c\u90a3\u4e48\u5b83\u4eec\u4f7f\u7528\u5b9e\u6570\u6bd4\u8f83\uff1b
\u2022 \u5982\u679c\u6240\u6709\u7684\u53c2\u6570\u662f\u5927\u5c0f\u5199\u654f\u611f\u7684\u5b57\u7b26\u4e32\uff0c\u90a3\u4e48\u53c2\u6570\u6bd4\u8f83\u4e5f\u662f\u5927\u5c0f\u5199\u654f\u611f\u7684\uff1b\u5176\u5b83\u60c5\u51b5\u4e0b\uff0c\u53c2\u6570\u6bd4\u8f83\u5927\u5c0f\u5199\u4e0d\u654f\u611f\u3002<\/p>\n\n\n\n\u5982\u4e0a\u6ce8\u610f\uff0c
1\u3001\u4e0d\u80fd\u6709NULL,\u5426\u5219\u8fd4\u56deNULL
2\u3001\u5982\u679c\u6709\u6570\u5b57\uff0c\u5219\u5168\u90e8\u6309\u6570\u5b57\u6bd4\u8f83\uff0c\u4f1a\u6709\u9690\u5f62\u8f6c\u6362\u3002 <\/p>\n\n\n\n
<\/span>\u6837\u4f8b<\/span><\/h2>\n\n\n\n<\/span>\u5168\u90e8\u6570\u5b57<\/span><\/h3>\n\n\n\ngbase> select greatest(1,2,3,4,5,6,7,8);\n+---------------------------+\n| greatest(1,2,3,4,5,6,7,8) |\n+---------------------------+\n| 8 |\n+---------------------------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u5168\u90e8\u5b57\u7b26\u4e32<\/span><\/h3>\n\n\n\ngbase> select greatest('a','A','b','c');\n+---------------------------+\n| greatest('a','A','b','c') |\n+---------------------------+\n| c |\n+---------------------------+\n1 row in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u6df7\u5408\u5b57\u7b26\u548c\u6570\u5b57<\/span><\/h3>\n\n\n\ngbase> select greatest('a','A','b','c',9);\n+-----------------------------+\n| greatest('a','A','b','c',9) |\n+-----------------------------+\n| 9 |\n+-----------------------------+\n1 row in set, 4 warnings (Elapsed: 00:00:00.00)\n\ngbase> show warnings;\n+---------+------+---------------------------------------+\n| Level | Code | Message |\n+---------+------+---------------------------------------+\n| Warning | 1292 | Truncated incorrect DOUBLE value: 'a' |\n| Warning | 1292 | Truncated incorrect DOUBLE value: 'A' |\n| Warning | 1292 | Truncated incorrect DOUBLE value: 'b' |\n| Warning | 1292 | Truncated incorrect DOUBLE value: 'c' |\n+---------+------+---------------------------------------+\n4 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u5305\u542bnull<\/span><\/h2>\n\n\n\ngbase> select greatest('a','A','b','c',null);\n+--------------------------------+\n| greatest('a','A','b','c',null) |\n+--------------------------------+\n| NULL |\n+--------------------------------+\n1 row in set (Elapsed: 00:00:00.00)\n\n<\/code><\/pre>\n\n\n\n<\/p>\n\n\n\n
<\/span>\u53c2\u8003<\/span><\/h2>\n\n\n\n<\/p>","protected":false},"excerpt":{"rendered":"
\u5357\u5927\u901a\u7528GBase 8a\u63d0\u4f9b\u4e86least\u51fd\u6570\uff0c\u8fd4\u56de\u53c2\u6570\u5217\u8868\u91cc\uff0c\u6700\u5c0f\u7684\u4e00\u4e2a\u503c\u3002\u4e0egreatest\u53d6\u6700\u5927\u503c\u60f3\u5bf9\u5e94\u3002\u8fd9\u4e2a\u662f\u9488\u5bf9\u5f53\u524d\u884c\u7684\u591a\u4e2a\u5217\u6216\u8868\u8fbe\u5f0f\u8ba1\u7b97\u7ed3\u679c\uff0c\u800cmin\u51fd\u6570\u662f\u591a\u884c\u7684\u67d0\u4e2a\u5217\u6216\u8868\u8fbe\u5f0f\u7684\u6700\u5c0f\u503c\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[36],"class_list":["post-2640","post","type-post","status-publish","format-standard","hentry","category-gbase8a","tag-36"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2640","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=2640"}],"version-history":[{"count":2,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2640\/revisions"}],"predecessor-version":[{"id":8193,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/2640\/revisions\/8193"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=2640"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=2640"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=2640"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}