mysql将大量数字转换为char

c3frrgcw 于 2021-06-17 发布在 Mysql

关注(0)|答案(1)|浏览(380)

英语不是我的母语；请原谅打字错误。
im使用5.5.38-mariadb。mysql语句：

SELECT CAST(11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111
AS char);

我得到的结果是 99999999999999999999999999999999999999999999999999999999999999999 ，为什么？
更新：

MariaDB [(none)]> SELECT CAST(199999999999999999999999999999999999999999999999999999999999999999999999999999999 AS char);
+-------------------------------------------------------------------------------------------------+
| CAST(199999999999999999999999999999999999999999999999999999999999999999999999999999999 AS char) |
+-------------------------------------------------------------------------------------------------+
| 199999999999999999999999999999999999999999999999999999999999999999999999999999999               |
+-------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> SELECT CAST(1999999999999999999999999999999999999999999999999999999999999999999999999999999999 AS char);
+--------------------------------------------------------------------------------------------------+
| CAST(1999999999999999999999999999999999999999999999999999999999999999999999999999999999 AS char) |
+--------------------------------------------------------------------------------------------------+
| 99999999999999999999999999999999999999999999999999999999999999999                                |
+--------------------------------------------------------------------------------------------------+
1 row in set, 1 warning (0.01 sec)

MariaDB [(none)]> SHOW WARNINGS;
+---------+------+--------------------------------------------------------------+
| Level   | Code | Message                                                      |
+---------+------+--------------------------------------------------------------+
| Warning | 1916 | Got overflow when converting '' to DECIMAL. Value truncated. |
+---------+------+--------------------------------------------------------------+
1 row in set (0.00 sec)

mysql mariadb

来源：https://stackoverflow.com/questions/53531101/mysql-cast-large-number-to-char

1条答案

按热度按时间

lfapxunr1#

这个 1111... 被解析为一个数字，特别是 DECIMAL(65, ...) . 65为最大值；因为这个东西比那个大，它给了你659分。它给了你一个警告（可能被忽略了）：

mysql> SELECT CAST(11111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111 AS CHAR) AS too_big;
+-------------------------------------------------------------------+
| too_big                                                           |
+-------------------------------------------------------------------+
| 99999999999999999999999999999999999999999999999999999999999999999 |
+-------------------------------------------------------------------+
1 row in set, 1 warning (0.00 sec)

mysql> SHOW WARNINGS;                                                                               
+---------+------+---------------------------------------+
| Level   | Code | Message                               |
+---------+------+---------------------------------------+
| Warning | 1292 | Truncated incorrect DECIMAL value: '' |
+---------+------+---------------------------------------+
1 row in set (0.00 sec)

你希望得到什么？

赞(0）回复(0）举报 2021-06-18

我来回答

mysql将大量数字转换为char

1条答案

相关问题

热门标签

最新问答