Hi,
Here i am again. I can select particular record by using
LIMIT 9,1
But e.g. if i want to delete this record then how shall i do ? I tried to use
Delete from table name Limit 9, 1
But i am getting erorr. pls can anybody let me know the exact syntax for this ?
regards
Manisha
On Monday 23 August 2004 11:08, Manisha Sathe might have typed:
Hi,
Here i am again. I can select particular record by using
LIMIT 9,1
But e.g. if i want to delete this record then how shall i do ? I tried to
use
Delete from table name Limit 9, 1
Said record is probably keyed in some
Manisha Sathe [EMAIL PROTECTED] wrote on 23/08/2004 11:08:10:
Here i am again. I can select particular record by using
LIMIT 9,1
But e.g. if i want to delete this record then how shall i do ? I
tried to use
Delete from table name Limit 9, 1
But i am getting erorr. pls can
if you dont want to add an auto-increment column,
you can probably specify ALL columns and their
values in WHERE clause and end with LIMIT 1.
eg:
DELETE FROM Table WHERE Column1=Value1 AND
Column2=Value2 ... LIMIT 1
--- Manisha Sathe [EMAIL PROTECTED] wrote:
Hi,
Here i am again. I can
: Monday, August 23, 2004 6:08 AM
To: [EMAIL PROTECTED]
Subject: How to delete records after particular position ?
Hi,
Here i am again. I can select particular record by using
LIMIT 9,1
But e.g. if i want to delete this record then how shall i do ? I tried to
use
Delete from table name Limit 9