Re: Incrementing Primary Key
| From: | Andrés G. Montañez | Date: | Wed, 27 Oct 2010 13:19:03 +0000 |
| Subject: | Re: Incrementing Primary Key | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47442@lists.php.net to get a copy of this message | ||
Hi Ethan,
in this case, you should manage the "keys" by your application, and
store the used ids in aonther table,
similar to a "sequence" in Oracle or Postgresql.
Thats so if you want all the records un one table (a field for the
letter, and the other for the numeric part).
Otherwise, having a table for each site will be enough, as Jimmy suggests.
--
Andrés G. Montañez
Zend Certified Engineer
Montevideo - Uruguay