I believe the syntax is
Delete from MyTable Where MyCriteria LIMIT HowMany.
God Bless
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
GOD BLESS AMERICA!
To God Be The Glory!
-Original Message-
From: Manisha Sathe [mailto:[EMAIL PROTECTED]
Sent: Mon
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
"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 Limit 9, 1
>
> But i am getting erorr. pls can an
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 Limit 9, 1
Said record is probably keyed in some m