abdelwaheb ammar

abdelwaheb ammar

  • 1.3k
  • 457
  • 124.7k

insetion request and update in the same time

Jan 1 2016 10:58 AM
hi, I'm looking on the net a query that allows for the inserting if there are no duplicates and  update if I find a duplicate, I find this syntax query
 
 INSERT INTO table (a, b, c) VALUES (1, 20, 68)
ON DUPLICATE KEY UPDATE a=a+1
 
in this links SQL ON DUPLICATE KEY UPDATE
but he says it is a MySQL functionality.
Does there-an equivalent of this in Access?
 

Answers (1)