Syntax problem create table

[bossyman]

Hello all,

I have to create a table. One of the columns (primary key) has to start with ex. "2006B" and after that there has to be an autoincrement.
Can anyone help me with the syntax if it is possible to have such a syntax ?

 

[r937]

use an ordinary auto_increment as the real primary key, and "assemble" your key value for every query like this --

select concat('2006B',lpad(id,8)) as concatkey
from yourtable

r937.com | rudy.ca