I'm Try to get my auto increment values to start in this sequence
000000 000001 000002 000003...
How can I do this using mysql as the database I tryed set in the default at 000000
but that didn't work
Help Thanks
It doesn't really work that way. Auto-increment columns are binary, and "leading zeros" are entirely an artifact of displaying a number in ascii characters within some implied field width. But take heart: you can format your numbers with leading zeros for display, if you like: see the manual page on printf() for more info.
