ç»è®ºï¼
- é»è®¤ç int ç±»åï¼åå¼èå´æ¯-2147483648-2147483647ä¹é´ï¼è unsigned çåå¼èå´æ¯0-4294967295ä¹é´ã
- é»è®¤ç int ç±»åï¼å 许æå ¥è´æ°ï¼unsigned 设置åï¼æ æ³æå ¥è´æ°ã
AUTO_INCREMENT
CREATE TABLE `test01` (
id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`name` varchar(60) DEFAULT ''
) ENGINE=InnoDB AUTO_INCREMENT=2147483647 DEFAULT CHARSET=utf8mb4 COMMENT='test01';
INSERT INTO test01(name) VALUES ('test 001');
æåæå ¥æ°æ®åï¼å¦ä¸å¾æ示ãAUTO_INCREMENT çå¼ä¸ºåå§å¼ã
select last_insert_id();
æ¤æ¶idçå¼ä¸º2147483648ã
INSERT INTO test01(name) VALUES ('test 002');
å¦æ以ä¸è¯å¥æ§è¡æåï¼åidçå¼å°±å为2147483649ãä½æ¯å®é ä¼æ¥éã
å 为idä¸è½åå¢å äºï¼åºç°idéå¤ã
int
主é®ä½ä¸ºidå¯ä»¥ä¸ºè´ï¼è¯·åâ
ID èªå¢è¶çæ¶ç解å³æ¹æ¡
æ¹æ¡1) å°intä¿®æ¹ä¸ºint(11) unsigned
ALTER TABLE test01 MODIFY COLUMN `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;