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 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
>
>
>
>
>
>
_______________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
http://promotions.yahoo.com/goldrush
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
