Insert dengan data hasil Select mysql

Query ini digunakan untuk menginsert data yang bersumber dari hasil query. Pastikan jumlah field yang akan diinsert sama dengan jumlah field hasil query data sumbernya.

 INSERT INTO tbl_temp2 (fld_id)  
  SELECT tbl_temp1.fld_order_id  
  FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;  

Read More

Insert or Update When Exists Mysql

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)

Read More