Re: Idea for pear sequence tables
| From: | Tomas V.V.Cox | Date: | Fri, 12 Sep 2003 16:35:53 +0000 |
| Subject: | Re: Idea for pear sequence tables | ||
| References: | 1 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-21444@lists.php.net to get a copy of this message | ||
On Friday, September 12, 2003 17:52, Stowe, Nola wrote:
> I'm sure someone has thought of this and you have a good reason for NOT
> doing it.. but..I'm curious on why you didn't do it this way?
> Instead of having another table created for each table I need a sequence on,
> what about having a sequence table (seq_name, seq_key) with rows for each
> table and then just fetching and updating that table with the next key?
Well, a sequences is just that a pool of unique id's for using in your
tables. I never understood why one would like to have multiple
sequences, while just one for all your tables is enough.
--
Tomas V.V.Cox mailto:cox@idecnet.com