jOOQ 3.15 will support multi table DELETE statements via explicit JOINs in FROM: https://github.com/jOOQ/jOOQ/issues/11924 and single table DELETE statements with USING clause: https://github.com/jOOQ/jOOQ/issues/11925
Listing the tables to delete from is not yet possible On Saturday, April 30, 2016 at 4:50:39 PM UTC+2 Lukas Eder wrote: > Hello, > > Thank you very much for this suggestion. This is currently not supported > in jOOQ, out-of-the-box. But it should be. I've created a feature request > for this: > https://github.com/jOOQ/jOOQ/issues/5230 > > In the meantime, you can resort to "plain SQL": > http://www.jooq.org/doc/latest/manual/sql-building/plain-sql > > Or to patching the SQL statement using an ExecuteListener. > > Cheers, > Lukas > > > 2016-04-29 21:49 GMT+02:00 jdoe <ua.s...@gmail.com>: > >> Hello! >> >> I'm wondering if there's any possibility to add table names between >> DELETE and FROM in order to make something like this (MySQL): >> >> DELETE *t1, t2* FROM t1 INNER JOIN t2 INNER JOIN t3 >> WHERE t1.id=t2.id AND t2.id=t3.id; >> >> -- >> 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/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 jooq-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/61c0ddfa-943c-48f2-8be5-a3c8a29c260an%40googlegroups.com.
