On 7/9/06, Jorge Bastos <[EMAIL PROTECTED]> wrote:
Hi,
Paul or somebody else, i need to create and delete accounts via SQL, to
create i have all tables i need to create and it's values, but for delete,
i'd like to delete not just the user account but it's alias and emails if
any exists, can you help?
[DELETE FROM dbmail_aliases WHERE deliver_to='246' AND lower(alias) =
lower('[EMAIL PROTECTED]')]
[DELETE FROM dbmail_users WHERE userid = '[EMAIL PROTECTED]']
[DELETE FROM dbmail_mailboxes WHERE owner_idnr='246']
There 3 i know i have to, wich more ?
Jorge
May I ask why you have to do that via sql?
I mean if you like to do that from a website you can execute dbmail-user via php
--
Demi