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 you don't know what the row number is. Even if you did, the number is not guaranteed to remain the same over time. The table should include a primary key, so that you can refer to each row in the table by its unique key number. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
