You can do some trickery with auto increment fields and multiple-column
indexes. Have a look at http://www.bitbybit.dk/carsten/blog/?p=131
Beware that this is apparently a MyISAM-specific trick.
/ Carsten
On Tue, 6 Apr 2010 16:02:48 +0530, "Suryanarayanan"
wrote:
> I am new to mysql a
I am new to mysql and am trying to develop a package in php using mysql as
backend database.
I have a table in mysql which has a customer code which is alpha numeric.
Eg: J0001 and name and address of the customer. The alphabet signifies the
first letter of the name of the customer viz. James.
