Tag:MySQL numeric type

  • Handling method of MySQL numeric type overflow

    Time:2021-1-20

    Let’s ask you a question. What happens when a column is set to int (0) in MySQL? To illustrate this problem, we need to create a table first DROP TABLE IF EXISTS `na`; CREATE TABLE `na` ( n1 INT(0) NOT NULL DEFAULT ‘0’, n2 INT(11) NOT NULL DEFAULT ‘0’ ); Then we use the following […]