Thanks! The code and links were very helpful! понедельник, 15 июня 2015 г., 10:19:45 UTC+3 пользователь Lukas Eder написал: > > When you're missing support for a vendor-specific function in jOOQ, the > easiest way to go forward is by using "plain SQL" > http://www.jooq.org/doc/latest/manual/sql-building/plain-sql > > In your case, the following code will help: > > public class MyDSL { > public static <T> Field<T> values(Field<T> field) { > return DSL.field("values({0})", field.getDataType(), field); > } > } > > You can now use the above VALUES clause in your INSERT .. ON DUPLICATE KEY > UPDATE statements. > > See also: > https://github.com/jOOQ/jOOQ/issues/2134 > > Hope this helps, > Lukas > > 2015-06-13 13:05 GMT+02:00 jdoe <[email protected] <javascript:>>: > >> How do I reference VALUES in ON DUPLICATE KEY UPDATE? >> >> INSERT INTO table (a,b,c) VALUES (1,2,3),(4,5,6) >> ON DUPLICATE KEY UPDATE c=VALUES(a)+VALUES(b); >> >> >> More about it: >> http://dev.mysql.com/doc/refman/5.6/en/miscellaneous-functions.html#function_values >> . >> >> -- >> 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 [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > >
-- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
