×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: sumesh tg
Added: Jan 26, 2017 7:17 AM
Views: 6
Tags: duplicate on
On Dupliacte Query
  1. INSERT INTO enquiry_assesment_status_tbl(assement_status_id,enquiry_status, enquiry_id, remarks,DATE)
  2. VALUES('as_76e24f3c8bca' ,'2', 'kol_88562439b038', 'hgjhgj', '2017-02-03')
  3.  ON DUPLICATE KEY
  4. UPDATE
  5. assement_status_id=VALUES(assement_status_id),
  6. enquiry_id=VALUES(enquiry_id),
  7. remarks=VALUES(remarks),
  8. DATE=VALUES(DATE),
  9. enquiry_status=VALUES(enquiry_status)