\u6765\u6e90:http:\/\/www.javaranger.com\/archives\/1098
\nmysql> select * from orders;
\n+—-+—————————+
\n| id | order_id |
\n+—-+—————————+
\n| 1 | 0300020140124034500255929 |
\n| 2 | 0300020140124034500268504 |
\n| 3 | 0300020140124034500648644 |
\n| 4 | 0300020140124034500268XXX |
\n| 5 | 0300020140124034500200000 |
\n| 6 | 0300020140124034500800000 |
\n+—-+—————————+
\n6 rows in set (0.00 sec)
\nmysql> select * from orders where order_id=0300020140124034500255929;
\n+—-+—————————+
\n| id | order_id |
\n+—-+—————————+
\n| 1 | 0300020140124034500255929 |
\n| 2 | 0300020140124034500268504 |
\n| 3 | 0300020140124034500648644 |
\n| 5 | 0300020140124034500200000 |
\n| 6 | 0300020140124034500800000 |
\n+—-+—————————+
\n5 rows in set, 1 warning (0.00 sec)
\n\u5148\u770border\u8868\u6570\u636e\uff0corder_id\u662fvarchar\u7c7b\u578b\uff0c\u6267\u884cselect\u7684\u67e5\u8be2\u6761\u4ef6\u6ca1\u6709\u52a0\u5355\u5f15\u53f7\uff0c\u8fd9\u65f6\u5019\u67e5\u8be2\u51fa\u67656\u6761\u7ed3\u679c\uff0c\u4e3a\u4ec0\u4e48\u4f1a\u51fa\u6765\u8fd9\u4e48\u591a\u7ed3\u679c\uff0c\u6309\u4e0a\u9762\u7684\u5199\u6cd5mysql\u4f1a\u628a\u4e0a\u9762\u7684\u6761\u4ef6order_id=0300020140124034500255929\u770b\u505a\u6570\u5b57\uff0c\u4f46\u662f\u770b\u505a\u4ec0\u4e48\u6570\u5b57\u4e0d\u662f\u5f88\u6e05\u695a<\/p>\n
\u5e2e\u52a9
\nmysql> show warnings;
\n+———+——+—————————————————————+
\n| Level | Code | Message |
\n+———+——+—————————————————————+
\n| Warning | 1292 | Truncated incorrect DOUBLE value: ‘0300020140124034500268XXX’ |
\n+———+——+—————————————————————+
\n1 row in set (0.00 sec)<\/p>\n
mysql> select * from doubles;
\n+—-+———————-+
\n| id | order_id |
\n+—-+———————-+
\n| 1 | 3.000201401240345e23 |
\n| 2 | 3.000201401240345e23 |
\n| 3 | 3.000201401240345e23 |
\n+—-+———————-+
\n\u4ecewarning\u4e0a\u6765\u770b\u662f\u8f6c\u4e3adouble\u4e86\uff0c\u628aorder_id\u7684\u7c7b\u578b\u53d8\u4e3adouble\u53d1\u73b0\u5b58\u50a8\u7684\u7ed3\u679c\u90fd\u53d8\u4e3a\u79d1\u5b66\u8ba1\u6570\u6cd5\u4e86\uff0c\u8fd9\u6837\u5c31\u627e\u5230\u539f\u56e0\u4e86\uff0c\u7ecf\u8fc7mysql\u9690\u5f0f\u8f6c\u6362\u7684\u7ed3\u679c\u4f1a\u6709\u7cbe\u5ea6\u4e22\u5931\uff0c\u9020\u6210\u4e86\u4e0a\u9762\u7684\u67e5\u8be2\u4e0d\u51c6\u786e<\/p>\n
\u6240\u4ee5\u5efa\u8bae\u5927\u5bb6\u4e0d\u8981\u501f\u52a9 MySQL \u7684\u9690\u5f0f\u8f6c\u6362\uff0c\u7a0b\u5e8f\u4e25\u683c\u6309\u6570\u636e\u7684\u672c\u6765\u7c7b\u578b\u6765\u5904\u7406\uff0c\u4f1a\u5c11\u5f88\u591a\u4e0d\u5fc5\u8981\u7684\u9ebb\u70e6\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u6765\u6e90:http:\/\/www.javaranger.com\/archives\/10 …<\/p>\n