You are here: RE: [PHP] 4 Digit ID with Leading Zeros « PHP « IT news, forums, messages
RE: [PHP] 4 Digit ID with Leading Zeros

Posted by Jim Moseby on 12/15/05 18:00

>
> I'm looking into the ZEROFILL option now. Didn't know about
> it before but it
> looks promising and probably is my solution. I'll get back.

Obviously, with a 4 digit id, you will only be able to store 10,000 records.
If I recall correctly, MySQL auto-increment fields will not reuse id's when
they are deleted. So, you will need to take that into consideration when
(if) you reach the 9,999th record.

JM

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация