display unsigned zerofill autoincrement value without leading zero
Posted
by I Like PHP
on Stack Overflow
See other posts from Stack Overflow
or by I Like PHP
Published on 2010-03-15T12:55:16Z
Indexed on
2010/03/15
13:19 UTC
Read the original article
Hit count: 286
my primay key is user_id which is auto incremant UNSIGNED ZERO FILL, i want to display user_id on a page without leading Zero( means 1 instead of 0000000001 )..
how can we do that in php or in mysql
one more question...
if i delete last record( let user_id=21) wwhich have highest id of that table then can we adjust auto increment value to 21 instead of 22 of that table.
© Stack Overflow or respective owner
