The reason for this is probably because the original poster inherited
a database without a primary key, and now needs to make edits to it.
That happened to me with Oracle once, and I was lucky enough to be
able to use Oracle's rowid, which is a unique reference to the row
that is independent of th
At 14:13 +0530 8/10/06, <[EMAIL PROTECTED]> wrote:
Hi All,
Is there any way to refer a row based on the row number or
row count?
I just the effect as below...
E.g. UPDATE TBL_NAME SET COL_NAME = xyz WHERE ROW_NO=4
Or SELECT COL_NAME FROM TBL_NAME WHERE ROW_NO=5
No, because
Bartis, Robert M (Bob) wrote:
> Why would you want to do this? As data moves around within the table the
> updates will be in error. Wouldn't it be easier to assign a unique key to
> each row, search for the key or unique set of information and update the
> resulting row?
>
> Bob
I don't know,
ECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 10, 2006 4:43 AM
To: mysql@lists.mysql.com
Subject: Can a row be refered using row number?
Hi All,
Is there any way to refer a row based on the row number or
row count?
I just the effect as below...
E.g. UPDATE TBL_NAME SET COL
At 03:43 AM 8/10/2006, you wrote:
Hi All,
Is there any way to refer a row based on the row number or
row count?
I just the effect as below...
E.g. UPDATE TBL_NAME SET COL_NAME = xyz WHERE ROW_NO=4
Or SELECT COL_NAME FROM TBL_NAME WHERE ROW_NO=5
Regards,
Ravi K
Ravi
Hi All,
Is there any way to refer a row based on the row number or
row count?
I just the effect as below...
E.g. UPDATE TBL_NAME SET COL_NAME = xyz WHERE ROW_NO=4
Or SELECT COL_NAME FROM TBL_NAME WHERE ROW_NO=5
Regards,
Ravi K
The information contained in this electr