Jorge Bastos wrote: > Hum, the sql seams ok, The sql is OK. But the deleted_flag is redundant.
UPDATE dbmail_messages SET status=2 where message_idnr = XXX; is quite sufficient. > You must use: > --- > dbmail-util -pd -y > --- > > If you don't specify the "y" option he won't do anything, this is like a > confirm. (anyone correct me if i'm wrong) Indeed. Without the -y switch you're just doing dry runs. > > Jorge > > > > ----- Original Message ----- From: "Kovid Goyal" <[EMAIL PROTECTED]> > To: "DBMail mailinglist" <[email protected]> > Sent: Sunday, June 11, 2006 7:20 AM > Subject: [Dbmail] deleting mails via sql > > >> Hi, >> >> Is this the correct MySQL query to delete a message: >> UPDATE dbmail_messages SET deleted_flag=1, status=2 WHERE >> message_idnr=1234; >> >> The reason I ask is that running dbmail-util -pd repeatedly doesn't >> seen to >> remove the message from dbmail_messageblks (dbmail-2.1.6) -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl
