set null value using update query

751 views

Skip to first unread message

unread,

Aug 7, 2013, 1:29:16 PM8/7/13

to jooq...@googlegroups.com

What is the equivalent jOOQ code for the query below?

UPDATE Employee SET Name = NULL WHERE Name = 'Unknown'

unread,

Aug 8, 2013, 5:33:31 AM8/8/13

to jooq...@googlegroups.com

Hi Venkat

2013/8/7 Venkat Sadasivam <venka...@gmail.com>

What is the equivalent jOOQ code for the query below?

UPDATE Employee SET Name = NULL WHERE Name = 'Unknown'

DSL.using(...)

.update(Employee)

.set(Employee.Name, null)

.where(Employee.Name.eq("Unknown"))

.execute();

More details here:

Reply all

Reply to author

Forward

0 new messages