List:General Discussion« Previous MessageNext Message »
From:Stephane MAGAND Date:March 17 2010 8:07am
Subject:SQL command for MySQL ?
View as plain text  
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 requets for said if the
WHERE don't exist, he create it !
(if he don't have dom_id=4 AND Date_Start="2010-03-16 06:00:00" AND
Date_End="2010-03-16 06:59:59" he
create by in INSERT) (a IF NO EXIST ?)


thanks
Stephane
Thread
SQL command for MySQL ?Stephane MAGAND17 Mar
  • Re: SQL command for MySQL ?Chris W17 Mar