> Is there a way to delete records in a table by specifying row numbers.
for
> example:
>
> delete from tbl1 where row > 900 and row <1000;
How do you get hold of the row numbers? The rows in the database are NOT
the same as the rows in
any particular SELECT you may have done. How the database stores the data
internally is its private
business.
So generally, the answer is no. But if you provide some sort of ORDER BY
clause, you ought
you be able to use the field you have ordered by to select the records for
deletion. For example,
if you haven't already got an autoincrement key, add one and order by it.
You will then be able to
delete using that key.
Alec Cawley
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
