Hi.
Please start a new thread next time instead of replying to an existing
one with a different topic. Mailers supporting threading will put your
mail under the original thread. Thank you.
On Tue, Apr 23, 2002 at 03:23:04PM +0800, [EMAIL PROTECTED] wrote:
Do anyone know how to select or get
If the value was set with AUTO_INCREMENT, then immediately after inserting
the row, do:
SELECT last_insert_id() AS myvalue;
-Original Message-
From: Ing. Gustavo Edelstein [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 14, 2002 10:03 AM
To: [EMAIL PROTECTED]
Subject: ROW ID
Hi list
]
Technical: [EMAIL PROTECTED]
Web related: [EMAIL PROTECTED]
General: [EMAIL PROTECTED]
- Original Message -
From: Rick Emery [EMAIL PROTECTED]
To: 'Ing. Gustavo Edelstein' [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Monday, January 14, 2002 1:27 PM
Subject: RE: ROW ID
If the value was set
: 14 January 2002 16:58
To: Rick Emery; [EMAIL PROTECTED]
Subject: Re: ROW ID
What I mean is to get the internal id of every existing row in a table.
Thanks.
Ing. Gustavo A. Edelstein
Tech. Mgr.
Equiplus Argentina S.A.
__
Visit us On Line at www.equiplus.com
: [EMAIL PROTECTED]
- Original Message -
From: Peter Dunham [EMAIL PROTECTED]
To: Ing. Gustavo Edelstein [EMAIL PROTECTED]; Rick Emery
[EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, January 14, 2002 2:30 PM
Subject: RE: ROW ID
You need to specify an 'id' column when creating the table