开发者

MySQL National Stock Numbers (NSN) for identification of assets

开发者 https://www.devze.com 2022-12-28 01:05 出处:网络
In MySQL are there any restrictions (and/or) practical reasons against using a numbering system similiar to the National Stock Number format as follows 3728-01-234-5678 (this format includes the use o

In MySQL are there any restrictions (and/or) practical reasons against using a numbering system similiar to the National Stock Number format as follows 3728-01-234-5678 (this format includes the use o开发者_运维技巧f the hyphen between groups of characters within the structure)

Would this require the use of a specific engine like InnoDB

A newbie student


The only issues I see with this is that you will have to implement your own AUTO_INCREMENT and store this in a string/varchar type fields.

This might take more space than a normal auto increment.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号