Formatting an Auto Increment Field

[vicky666]

I would like to create a unique key with the format G0200000 (G02 Must not be changed) to be incremented automatically (G0200001, G0200002, etc) when a new record is created. I know this problem was posted earlier but the result wouldnt work on my mysql command prompt.The attribut to be incremented is call BookingId and The table is called Booking. Can anyone please help? thanks

Vicky

 

[sleipnir214]

Treat the "G02" part of the ID as presentation information.

Store only the integer auto_incremented ID in the table, and prepend "G02" to the record when you display it. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[4x4uk]

If G02 never changes then just use a standard auto increment field either put G02 in a spearate field and add the 2 together later or better still if it never changes just add it to the query result It's not a lie if you believe it!

http://www.ne4x4.org.uk/

|

http://www.ne4x4.org.uk/Ian/

|

http://www.ne4x4.fsnet.co.uk/beck/

 

[swampBoogie]

>> but the result wouldnt work on my mysql command prompt. >>

Why?

Besides, there is no (practical) alternative to doing it when selecting.

 

[vicky666]

Cheers for the help guys