RE: [PEAR] Pear DB LastInsertID
| From: | LIMBOURG Arnaud | Date: | Wed, 10 Jul 2002 09:05:30 +0000 |
| Subject: | RE: [PEAR] Pear DB LastInsertID | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-1835@lists.php.net to get a copy of this message | ||
The advantage of a sequence is that it is *not* linked to a table.
Specifiying a table and a column isn't the best way to go imho.
Arnaud.
> The best way IMO would be to change the nextID function to take two
> parameters: table_name and col_name. It would be up to the
> end user to
> create a sequence on the table column (in databases that
> supported it) -
> and for databases that don't the driver class could behave as
> they do at
> the moment, creating another table and updating the number in
> the column.