Re: delete with an offset?

[Dobromir Velev]

I don't think it is possible at least not with one query. You can limit the 
numbers of record to delete, but at least until 4.1 there is no offset. 
Probably you can do it with a subselect like this

delete from where to_uid=1 and read_timestamp0 and timestamp(select 
timestamp from messages  where to_uid=1 and read_timestamp0 order by 
timestamp desc limit 100,1)

HTH
-- 
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/

On Friday 21 October 2005 11:44, Eric Persson wrote:
 Hi,

 Is it possible to delete from a table with some sort of offset? I did
 the following select query, which selects a message from a message table.

 select id, subject from messages where to_uid=1 and read_timestamp0
 order by timestamp desc limit 3,1;

 The reason is I only want it to be 3 messages per to_uid, so id thought
 I would be able to delete from the third message and forward with
 something like.

 delete from messages where to_uid=1 and read_timestamp0 order by
 timestamp desc limit 3,1000;

 What I basically want is it to delete all messages above 100 for each
 user, any clues on how to solve this?

 Best regards,
  Eric


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: delete with an offset?

[Eric Persson]

Dobromir Velev wrote:
delete from where to_uid=1 and read_timestamp0 and timestamp(select 
timestamp from messages  where to_uid=1 and read_timestamp0 order by 
timestamp desc limit 100,1)


HTH


Thanks for your answer, I guess i'll have to do with two queries, but it 
looked like such and idea that someone might have thought about it 
before. ;)


thanks,
Eric

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]