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.
精彩评论