ot;Andrew Schmidt" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Thursday, August 16, 2001 12:50 PM
>Subject: Re: auto_increment vs. heap tables
>
>
> > Uh oh... Please NO. I want the standard _FAST_ auto_increment, not this.
> > "select max(id
#x27;" <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 1:02 PM
Subject: RE: auto_increment vs. heap tables
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Except, if you have a table like so:
>
> ++-+
> | id | num |
> ++-+
> |
ct the
max(sess_id).
well anyway, sorry I couldn't help more.
thanks,
-- Andrew
- Original Message -
From: "Leos Bitto" <[EMAIL PROTECTED]>
To: "Andrew Schmidt" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 12:50 PM
"Leos Bitto" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, August 14, 2001 6:05 AM
> Subject: auto_increment vs. heap tables
>
>
> > Hello,
> >
> > I am currently changing a simple PHP4-based application from PostgreSQL
> &g
id recieved from the select.
so doing it manually with heap tables seems quite feasable just a little
extra work.
thanks,
-- Andrew
- Original Message -
From: "Leos Bitto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 14, 2001 6:05 AM
Subject: a
On Wed, 15 Aug 2001, Jeremy Zawodny wrote:
> On Tue, Aug 14, 2001 at 12:05:08PM +0200, Leos Bitto wrote:
> > Hello,
> >
> > I am currently changing a simple PHP4-based application from
> > PostgreSQL 7.1 to MySQL 3.23.
>
> Welcome to MySQL, then. :-)
I am already using MySQL a lot, and now I am
On Tue, Aug 14, 2001 at 12:05:08PM +0200, Leos Bitto wrote:
> Hello,
>
> I am currently changing a simple PHP4-based application from
> PostgreSQL 7.1 to MySQL 3.23.
Welcome to MySQL, then. :-)
> I have some tables in the database which I would like to create as
> TYPE=HEAP in MySQL. Because I
Hello,
I am currently changing a simple PHP4-based application from PostgreSQL
7.1 to MySQL 3.23. I have some tables in the database which I would like
to create as TYPE=HEAP in MySQL. Because I have read the MySQL manual
(applause here, please!) I know that auto_increment cannot be used there.
T
