auto increment question

[VenusJ]

hi,
i was wondering how I can start the first user id in my database from ABC0001 instead of 1.

I currently have something like that:

CREATE TABLE classmates (
classmate_id int(11) NOT NULL auto_increment,
....

)

Any help is appreciated.
thanks

[ultraslacker]

You can emulate this by using a complex key,consisting of one column as an auto_increment integer (10001) and a second column as the prefix ('ABC').

auto_increment man page