Autoincrement in mysql field

Hello all,

i am working on an application for that i need to use a
mysql table in
which id field also exist and i need this field to start
with "
0000001" and increment accordingly.

is that possible and how. any query???

any help??

thanks
Sunil...


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---

Just store it as '1' and display it as '0000001'.
Similarly, any query
for, say '0000001' can be easily interpreted as '1'


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the
Google Groups "PHP & MySQL" group.
To post to this group, send email to phpmysqlgooglegroups.com
To unsubscribe from this group, send email to
phpmysql-unsubscribegooglegroups.com
For more options, visit this group at http://groups
.google.com/group/phpmysql
-~----------~----~----~----~------~----~------~--~---