Pear db to create tables

Pear db to create tables

am 31.01.2007 12:14:35 von lobo

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

Re: Pear db to create tables

am 31.01.2007 12:25:02 von Captain Paralytic

On 31 Jan, 11:14, Lobo 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

Re: Pear db to create tables

am 31.01.2007 12:26:37 von Captain Paralytic

On 31 Jan, 11:25, "Captain Paralytic" wrote:
> On 31 Jan, 11:14, Lobo 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/

Re: Pear db to create tables

am 31.01.2007 12:57:45 von lobo

Captain Paralytic a écrit :
> On 31 Jan, 11:25, "Captain Paralytic" wrote:
>> On 31 Jan, 11:14, Lobo 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 :/