Jooq INSERT on duplicate key UPDATE

364 views
Skip to first unread message

Павел Туз

unread,
Jan 9, 2014, 9:36:08 AM1/9/14
to jooq...@googlegroups.com

Trying to use "jooq" to work with db (MySQL). It looks like nice, but as sql query more complex jooq construction more obscure.

Is anybody know what code should I write to get SQL-analog for:

INSERT INTO table (field1, field2, counter) VALUES (123, abc, 10), (124, cde, 20)
ON DUPLICATE KEY UPDATE counter = counter + VALUES(counter); 

?

Lukas Eder

unread,
Jan 10, 2014, 2:09:40 AM1/10/14
to jooq...@googlegroups.com
Hello,

This particular vendor-specific syntax is not yet supported by jOOQ 3.2. It is on the long-term roadmap as #2134:

Cheers
Lukas


2014/1/9 Павел Туз <tuzp...@gmail.com>

--
You received this message because you are subscribed to the Google Groups "jOOQ User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

Reply all
Reply to author
Forward
0 new messages