[SOLVED] How do you use auto_increment in perticular format

[adi5402]

I have s simple question

 

how do i enter data in a form were the primary field is set to auto increment but i want the number in a given formart say starting from 10050 up and has an A at the end So it will be soemthing like A100050 for my first enty

 

any ideas

 

[Mchl]

Autoincrement column can only be INT so no letters.

To set up a starting value you need to do query like this one

ALTER TABLE tablename AUTO_INCREMENT = 100050

 

Note, that autoincrement columns should be used only for internal database stuff. No real life numbers should be generated like that.

[adi5402]

So if i change the first one to 100050 the next entry will automaticly beceome 100051

 

im trying to gernerate invoices how can i assign them number that way.

 

 

[adi5402]

ya man that worked great thanks