插入MYSQL服务器时的随机值 [英] Random value when inserting in MYSQL server

问题描述

出于某种原因，当我将'2015041200000000'插入INT（20）字段时，我变成'2147483647'...

For some reason, when I insert '2015041200000000' into an INT(20) field I turns into '2147483647'...

这怎么可能？

我这样做是因为我想用php将自动递增的ID格式化为YYYYMMDDXXXXXXXX。

I'm doing this because I want to format the auto incremented ID to YYYYMMDDXXXXXXXX with php.

谢谢提前

推荐答案

2147483647远非随机值。它是带符号的32位整数的最大值，因此INT数据类型不足以存储您尝试使用的值。你可能想尝试BIGINT。

2147483647 is far from a "random value". It's the maximum value of a signed 32-bit integer, so an INT data type is not enough to store the value you're trying to use. You may want to try BIGINT instead.

https://en.wikipedia.org/wiki/2147483647#In_computing
https://dev.mysql.com/doc/refman/5.1/en/integer-types.html

这篇关于插入MYSQL服务器时的随机值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！