Pear db to create tables

Hi
i want to use pear to create tables, i want to make requests compatible
with every db types pear can handle.
Where can i find sql reference (not mysql/oracle/postgresql reference) ?
example :
CREATE TABLE `administrateur` (
`id_admin` INTEGER NOT NULL auto_increment, ...
will auto_increment be compatible with all those db ?

thanks
lobo [ Mi, 31 Januar 2007 12:14 ] [ ID #1614409 ]

Re: Pear db to create tables

On 31 Jan, 11:14, Lobo <l... [at] lobo.com> wrote:
> Hi
> i want to use pear to create tables, i want to make requests compatible
> with every db types pear can handle.
> Where can i find sql reference (not mysql/oracle/postgresql reference) ?
> example :
> CREATE TABLE `administrateur` (
> `id_admin` INTEGER NOT NULL auto_increment, ...
> will auto_increment be compatible with all those db ?
>
> thanks

http://www.iso.org/iso/en/CatalogueListPage.CatalogueList?IC S1=35&ICS2=60&ICS3
Captain Paralytic [ Mi, 31 Januar 2007 12:25 ] [ ID #1614410 ]

Re: Pear db to create tables

On 31 Jan, 11:25, "Captain Paralytic" <paul_laut... [at] yahoo.com> wrote:
> On 31 Jan, 11:14, Lobo <l... [at] lobo.com> wrote:
>
> > Hi
> > i want to use pear to create tables, i want to make requests compatible
> > with every db types pear can handle.
> > Where can i find sql reference (not mysql/oracle/postgresql reference) ?
> > example :
> > CREATE TABLE `administrateur` (
> > `id_admin` INTEGER NOT NULL auto_increment, ...
> > will auto_increment be compatible with all those db ?
>
> > thanks
>
> http://www.iso.org/iso/en/CatalogueListPage.CatalogueList?IC S1=35&ICS...

This is useful too:
http://troels.arvin.dk/db/rdbms/
Captain Paralytic [ Mi, 31 Januar 2007 12:26 ] [ ID #1614411 ]

Re: Pear db to create tables

Captain Paralytic a écrit :
> On 31 Jan, 11:25, "Captain Paralytic" <paul_laut... [at] yahoo.com> wrote:
>> On 31 Jan, 11:14, Lobo <l... [at] lobo.com> wrote:
>>
>>> Hi
>>> i want to use pear to create tables, i want to make requests compatible
>>> with every db types pear can handle.
>>> Where can i find sql reference (not mysql/oracle/postgresql reference) ?
>>> example :
>>> CREATE TABLE `administrateur` (
>>> `id_admin` INTEGER NOT NULL auto_increment, ...
>>> will auto_increment be compatible with all those db ?
>>> thanks
>> http://www.iso.org/iso/en/CatalogueListPage.CatalogueList?IC S1=35&ICS...
>
> This is useful too:
> http://troels.arvin.dk/db/rdbms/
>

thank you

.... i'll have to make requests for each db type :/
lobo [ Mi, 31 Januar 2007 12:57 ] [ ID #1614413 ]
PHP » alt.php.sql » Pear db to create tables

Vorheriges Thema: How to write a query, filling in dates that aren't there.
Nächstes Thema: SHOW TABLES, SELECT and REGEXP