Primary Key Question

[A5k]

Is it possible to automatically take an auto incremented primary key, concat a prefix and place it into another column of the same table?
I know this can be achieved in MS SQL using the Formula field in the Enterprise manager but I'm wondering if there's a similar way in MySQL.

Thanks,
Dave

 

[r937]

don't think so

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (course starts January 9 2005)

 

[A5k]

dang