Vignesh
2011-11-08 21:05:53 UTC
We know that id of any table is of integer type and auto-increment in
that table is fine. But my problem is that i want to increment a
combination of string and integer. For example String : ABC is the
starting code for the unique id.
First Id of my table should be primary key and
ie ABC10001, ABC10002,..... and so on.
Without using another key as auto-increment. Please do not use two
type of unique key.
that table is fine. But my problem is that i want to increment a
combination of string and integer. For example String : ABC is the
starting code for the unique id.
First Id of my table should be primary key and
ie ABC10001, ABC10002,..... and so on.
Without using another key as auto-increment. Please do not use two
type of unique key.