What type should I use to create an ID number composed of letters and numbers and which will also increment, e.g. "HP0001" increment to "HP0002"
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效，请关闭广告屏蔽插件后再试):
问题:
回答1:
Varchar of "X" lenght, or 2 fields, 1 varchar and another numeric, both has to be primary keys
You can check what im talking about in this example:
http://sqlfiddle.com/#!2/df078/4
