Re: Newbie DB Sequence Question

From: Date: Fri, 19 Mar 2004 10:21:49 +0000
Subject: Re: Newbie DB Sequence Question
References: 1  Groups: php.pear.general 
Request: Send a blank email to pear-general+get-11393@lists.php.net to get a copy of this message
Paul Burney wrote:
I'm trying to use PEAR-DB for a project that uses MySQL as its database. I've having trouble with sequences. I don't mind so much that they create an additional table, but they don't seem to check what data is in the table (i.e., getting the max id in the table) before being created.
No, sequences live independant of a specific table. This makes them more flexible, but also require that the developer makes sure that they are initialized properly. MDB has the ability to store this semantics into its xml schema format. However moving to this format will require alot of rethinking usually, but it may be worth it in the long run. See the following article for details in case you are interested: http://www.php-mag.net/itr/online_artikel/show.php3?id=283&nodeid=114 regards, Lukas Smith smith@backendmedia.com _______________________________ BackendMedia www.backendmedia.com berlin@backendmedia.com Linn Zwoch Smith GbR Pariser Str. 44 D-10707 Berlin Tel +49 30 83 22 50 00 Fax +49 30 83 22 50 07

« previous php.pear.general (#11393) next »