create a attribute auto start with aaaa by 1

[xbl01234]

Hello;
How i can create a attribute auto start with aaaa by 1.

for example;
create table tset2(cid int primary key auto_increment,
topic varchar(100),
content varchar(100),
referNo varchar start "aaaa" auto_increment,
full text(topic, content, referNo))

i want the referNo auto start with aaaa by 1

[FalseDawn]

It's not entirely clear what you are trying to do, but a table can only have one AUTO_INCREMENT column, and that must be numeric (integer)

[xbl01234]

i see, i will leave the varchar, and let the primary key auto increse.

>It's not entirely clear what you are trying to do

i just do some pratical, nothing else.

Thanks a lot