MYSQL Insert on Duplicate

Question

I'm trying to run the following statement:

INSERT INTO table (
    as,
    ad
    ,af,
    ag,
    ah,
    aj
)                                       
VALUES (
    'a',
    'b',
    'c',
    'd',
    'e',
    'f'
)
ON DUPLICATE KEY UPDATE (
    aj='dv',
    ah='ev',
    ag='fv'
);

and getting the following error:

You have an error in your SQL syntax; 
check the manual that corresponds to your MySQL server version for the 
right syntax to use near '(ag='dv',ah='ev',ah='fv')' 
at line 3

Any advice?

thx

remove (), use only english='dv',indonesian='ev',japanese='fv' — Milan Halada
– Milan Halada, Commented Apr 20, 2012 at 10:42

barsju · Accepted Answer · 2012-04-20 10:42:56Z

5

Skip the ()..

 INSERT INTO site_domains_meta 
 (domainname,metatype,pagename,english,indonesian,japanese)
  VALUES ('a','b','c','d','e','f')
  ON DUPLICATE KEY UPDATE english='dv',indonesian='ev',japanese='fv';

http://dev.mysql.com/doc/refman/5.5/en/insert.html

answered Apr 20, 2012 at 10:42

barsju

4,4561 gold badge23 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Simon at The Access Group Over a year ago

As an addition, you can use VALUES() instead of re-specifying data, i.e. ON DUPLICATE KEY UPDATE english = VALUES(english), indonesian = VALUES(indonesian), japanese = VALUES(japanese) as then it can update multiple-row inserts too with the correct values

Adam Over a year ago

perfect... thx... will tick once the time limit expires... cheers

Collectives™ on Stack Overflow

MYSQL Insert on Duplicate

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related