first off, stop using mysql, it's for amateurs,
use postgresql.

and yes, just use a trigger.
----------------------------------------
> From: [EMAIL PROTECTED]
> To: [email protected]
> Date: Wed, 3 Sep 2008 13:57:32 +0200
> Subject: [Dbmail] trigger for new messages
> 
> Hi there,
> 
> I have one more question:
> 
> the webmail system I wrote is almost done but at the moment I have
> something that is not really working as I would like it too: checking  
> for
> new messages. I do that by polling the database for it, but I suppose
> you guys have a nice way to fix that via a trigger within the mysql db?
> 
> Like having a table called: new_mail and update/insert entries there
> based on a MySQL trigger? I have no idea where and how I  could
> put that into the current db scheme of dbmail without breaking/
> generating other problems ...
> 
> Thanks for your time!
> 
> greetings,
> Daniel
> _______________________________________________
> DBmail mailing list
> [email protected]
> https://mailman.fastxs.nl/mailman/listinfo/dbmail

_________________________________________________________________
Stay up to date on your PC, the Web, and your mobile phone with Windows Live.
http://clk.atdmt.com/MRT/go/msnnkwxp1020093185mrt/direct/01/_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to