View: MySQL [UPDATE...IF NOT FOUND THEN...INSERT]

  1. MySQL [UPDATE...IF NOT FOUND THEN...INSERT]
    5 months ago by spirit
    1. # MySQL has 2 methods for handling this:
    2.  
    3. REPLACE INTO people(id,name,email) VALUES (in_id, in_name, in_email);
    4.  
    5. INSERT INTO people(id,name,email) VALUES (in_id, in_name, in_email) ON DUPLICATE KEY UPDATE name='$in_name', email='$in_email';
    View source

0 comment about "MySQL [UPDATE...IF NOT FOUND THEN...INSERT]"