Thanks Lukas!. I overlooked the obvious one. Worked like a charm !.
On Monday, 8 September 2014 21:35:06 UTC+5:30, Lukas Eder wrote: > > Hello, > > In order to express column expressions, simply call the relevant methods > on the column literals: > > COLUMN1.add(1); > > > More information here: > http://www.jooq.org/doc/latest/manual/sql-building/column-expressions > > Hope this helps, > Lukas > > 2014-09-08 17:25 GMT+02:00 Prem Nair <[email protected] <javascript:>>: > >> Hello >> Is there a way to increment the current value of a column on >> an onDuplicateKeyUpdate. ? >> >> Some thing like >> >> *.onDuplicateKeyUpdate().set(COLUM1,(COLUM1_VAL+1));* >> >> Thanks >> Prem >> >> -- >> 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.
