python 生成001开始的序号_自动生成的序列号从001开始（仅3位）-PHP / MYSQL

最新推荐文章于 2022-11-23 14:51:46 发布

weixin_39569894

最新推荐文章于 2022-11-23 14:51:46 发布

阅读量995

点赞数

文章标签： python 生成001开始的序号

本文链接：https://blog.csdn.net/weixin_39569894/article/details/111534221

版权

I need Auto generated sequence number staring from 001 ONLY FOR 3 DIGITS in PHP / MYSQL

ex: 001 next will be 002 and next will be 003 ... 009 .. 010 ..119..120..etc but number generated should be in sequence wise not like 001 then 120 or 008 etc , i need in sequence number.

actually i have product tracking system . where i need mixer of my main product id + auto sequence number ( only 3 digit can change if wanted ) hence my final product id becomes :

111-001 , 111-002 , 111-003 , 111-004 ....etc

Note: this auto sequence number will be insert in my mysql database ( after ADD button follows by Update query ( hence my auto sequence will be enter in database with Update query ))

解决方案

Just add the length 3 and zerofill to your id column.

ALTER TABLE `YOUR_TABLE` CHANGE

`id_column` `id_column` INT( 3 ) UNSIGNED ZEROFILL NOT NULL AUTO_INCREMENT