最近修改: 2025-10-09 09:48
systemctl restart mysqlmysql -u root -pSHOW ENGINE INNODB STATUS;SHOW FULL PROCESSLIST;| 类型 | 存储字节 | 范围(有符号/无符号) |
|---|---|---|
| TINYINT | 1 | -128, 127 |
| 0, 255 | ||
| SMALLINT | 2 | -32768, 32767 |
| 0, 65535 | ||
| MEDIUMINT | 3 | -8388608, 8388607 |
| 0, 16777215 | ||
| INT | 4 | -2147483648, 2147483647 |
| 0, 4294967295 | ||
| BIGINT | 8 | -9223372036854775808, 9223372036854775807 |
| 0, 18446744073709551615 | ||
| FLOAT | 4 | |
| DOUBLE | 8 | |
| DECIMAL | DECIMAL(M,D) -> M和D的值 |