_spaz Posted September 23, 2010 Share Posted September 23, 2010 Is is possible to auto increment an Alphanumeric number? example: AB001 AB002 ... ... BA001 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. 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... 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 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. Link to comment https://forums.phpfreaks.com/topic/214214-autoincrement-alphanumeric/#findComment-1115614 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.