SQL - IF EXISTS UPDATE ELSE INSERT INTO

Question

What I m trying to do is INSERT subscribers in my database  but IF EXISTS it should UPDATE the row  ELSE INSERT INTO a new row   Ofcourse I connect to the database first and GET the  name   email and  birthday from the url string    con mysqli connect  localhost   ---   ---   ---       Check connection if  mysqli connect errno          echo  Failed to connect to MySQL      mysqli connect error          name   GET  name      email   GET  email     birthday   GET  birthday      This works  but just adds the new row   mysqli query  con  INSERT INTO subs  subs name  subs email  subs birthday  VALUES    name     email     birthday       mysqli close  con     Here s what I tried   mysqli query  con  INSERT INTO subs  subs name  subs email  subs birthday  VALUES   name     email     birthday  ON DUPLICATE KEY UPDATE subs name   VALUES  name   subs birthday   VALUES  birthday     mysqli close  con     and  mysqli query  con  IF EXISTS  SELECT   FROM subs WHERE subs email   email       UPDATE subs SET subs name   name   subs birthday   birthday  WHERE subs email   email  ELSE     INSERT INTO subs  subs name  subs email  subs birthday  VALUES    name     email     birthday      mysqli close  con     and  mysqli query  con  IF NOT EXISTS SELECT   FROM subs WHERE subs email   email   Begin INSERT INTO subs  subs name  subs email  subs birthday  VALUES    name     email     birthday   End    mysqli close  con     But none of them work  what am I doing wrong   Any help is greatly appreciated

User · Accepted Answer

Create a UNIQUE constraint on your subs email column  if one does not already exist   ALTER TABLE subs ADD UNIQUE  subs email   Use INSERT     ON DUPLICATE KEY UPDATE   INSERT INTO subs    subs name  subs email  subs birthday  VALUES             ON DUPLICATE KEY UPDATE   subs name       VALUES subs name     subs birthday   VALUES subs birthday        You can use the VALUES col name  function in the UPDATE clause to   refer to column values from the INSERT portion of the INSERT     ON   DUPLICATE KEY UPDATE - dev mysql com    Note that I have used parameter placeholders in the place of string literals  as one really should be using parameterised statements to defend against SQL injection attacks

User · Answer

Try this  INSERT INTO  center course fee    fk course id   fk center code   course fee   VALUES   69    4920153    6000   ON DUPLICATE KEY UPDATE  course fee     6000

[mysql] SQL - IF EXISTS UPDATE ELSE INSERT INTO

Examples related to mysql

Examples related to sql

Examples related to insert

Examples related to exists