_spaz Posted September 23, 2010 Share Posted September 23, 2010 Is is possible to auto increment an Alphanumeric number? example: AB001 AB002 ... ... BA001 Quote Link to comment https://forums.phpfreaks.com/topic/214214-autoincrement-alphanumeric/ Share on other sites More sharing options...
PFMaBiSmAd Posted September 23, 2010 Share Posted September 23, 2010 Integer or floating-point data types can have the additional attribute AUTO_INCREMENT. Quote Link to comment https://forums.phpfreaks.com/topic/214214-autoincrement-alphanumeric/#findComment-1114628 Share on other sites More sharing options...
chintansshah Posted September 24, 2010 Share Posted September 24, 2010 NO... You can not... Quote Link to comment https://forums.phpfreaks.com/topic/214214-autoincrement-alphanumeric/#findComment-1115177 Share on other sites More sharing options...
Metalzed Posted September 24, 2010 Share Posted September 24, 2010 You could do a TRIGGER. Remove autocomplete. Use default value for the column. Then create a insert Trigger That changes the column value to what you want. Don't think it is a good sollution but think it will work. Goolge TRIGGER MYSQL for more help Quote Link to comment https://forums.phpfreaks.com/topic/214214-autoincrement-alphanumeric/#findComment-1115295 Share on other sites More sharing options...
fenway Posted September 25, 2010 Share Posted September 25, 2010 Yeah, don't. Quote Link to comment https://forums.phpfreaks.com/topic/214214-autoincrement-alphanumeric/#findComment-1115614 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.