[ic] Increment integer with preceding zeros
jt at endpoint.com
Sat Apr 5 21:58:19 CDT 2008
> Is there a way to increment an integer like 000001 to end up with
> 000002? The integer is stored in a MySQL table.
Not sure if MySQL has a function for this. Using auto increment is
better if this is an index.
In Perl you can use sprintf:
Where 6 is the desired width.
End Point Corporation
More information about the interchange-users