Lukas, Thanks and hope you had a good break. I have one more question: Can I do SELECT "Jack", 10, 20 FROM .... in jooq? I thought I could only use this construct if I am selecting 1 SELECT 1 FROM ...
Mohit. On Wed, Jul 9, 2014 at 1:17 AM, Lukas Eder <[email protected]> wrote: > Hello Mohit, > > I'm sorry for the delay. I was on a quick time off on Kos island... > > Your query is most certainly possible, but the SQL syntax you have in mind > is not valid. The INSERT .. VALUES statement does not allow for additional > predicates, you will have to use the INSERT .. SELECT statement, i.e. > > INSERT INTO t > SELECT u, v > FROM ... > WHERE NOT EXISTS ... > > A short example can be seen in the manual: > > http://www.jooq.org/doc/3.4/manual/sql-building/sql-statements/insert-statement/#N11532 > > Hope this helps, > Lukas > > > > 2014-07-03 22:09 GMT+02:00 Mohit Jaggi <[email protected]>: > >> Hi Fellow Jooqers, >> I did not find an example for the jooq way to "insert into T values (u, >> v) where not exists select..". Is that possible to do in jooq? >> >> Mohit. >> >> -- >> 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. >> > > -- 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.
