SQL command for MySQL ?

2010-03-17 Thread Stephane MAGAND
Hi i am debutant in SQL and i am search to know if it's possible: My SQL requets: UPDATE Table_Logs_Summary SET mails_recus=(mails_recus+1),mail_rbl=(mail_rbl+1) WHERE dom_id=4 AND Date_Start=2010-03-16 06:00:00 AND Date_End=2010-03-16 06:59:59; I wan't know if they have a optimised sql

Re: SQL command for MySQL ?

2010-03-17 Thread Chris W
I'm not 100% sure I understand what you are wanting but if I do, the INSERT ... ON DUPLICATE KEY UPDATE Syntax detailed here http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html Will probably do what you want. For it to work you would have to have a unique key on the three