On Fri, 18 Apr 2008 11:31:54 -0700 (PDT), Fabio wrote:
> How can I acomplish that?
>
> I want a field in my table to autoincrement like 'CHD0001', 'CHD0002',
> 'CHD0003'

Can't do it straight. Can CONCAT('CHD', CAST(my_id as CHAR)) on select
though, where my_id is your autoincrement, zerofill int(5) column.

--
76. If the hero runs up to my roof, I will not run up after him and struggle
with him in an attempt to push him over the edge. I will also not engage
him at the edge of a cliff. (In the middle of a rope-bridge over a river
of molten lava is not even worth considering.) --Evil Overlord List