Re: [Phpwebsite-developers] PEAR DB and auto_increment

[Don S. <do...@se...>]

It looks like the PEARy way of doing things is to use PEAR Sequences:
http://pear.php.net/manual/en/core.db.tut_sequences.php

I got this info from the PEAR mailing list when I asked about them:

"When you first use a sequence PEAR::DB creates it in the DB, so you don't
*have* to create it beforehand, you can though, in which case it has to be
of the form 'sequencename_seq' without the quotes and if you left the
default values. You can change the format of the string used to create the
sequence to match your own preferences.
                                                                                
If you create it you must not set it to autoincrement but better to INT
unsigned."

Has PEAR sequences been looked at before?

Just curious,
Don.

On Fri, 18 Oct 2002, Don Seiler wrote:

> In the install.sql for core and some modules (gallery I've seen), you have 
> create table statements that use "auto_increment" to define a field as 
> sequential.
> 
> Isn't auto_increment a mysql function and not standard across databases?  
> I don't see it in postgres and I'm pretty sure it won't fly in Oracle.
> 
> I want to use PEAR for database abstraction but using mysql-specific 
> syntax kind of defeats the purpose.
> 
> Am I mistaken?
> 
> Don.
> 
> 
> 
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> Phpwebsite-developers mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpwebsite-developers
>