plz help chk this query ??

[Veneet Raina]

create table Dummy
(
id int AUTO_INCREMENT,
userid 'C' + cast(id as varchar(10))
)


i want it to work in MYsql

any advice
i need a alphanumeric field soHELP