Note, the JOIN clause is available via any Table. Just use Table.crossJoin(Table): http://www.jooq.org/javadoc/latest/org/jooq/Table.html#crossJoin-org.jooq.TableLike-
The various JOIN clauses that are available from the Select API are mere convenience. 2015-01-28 13:27 GMT+01:00 Lukas Eder <[email protected]>: > Hello, > We currently don't explicitly support some of the MySQL-specific features > that you've listed. In particular, we don't have support for: > > - Variables: https://github.com/jOOQ/jOOQ/issues/2558 > - UPDATE ... ORDER BY: https://github.com/jOOQ/jOOQ/issues/714 > > However, you can work around both limitations using > > - Plain SQL for the variables: > http://www.jooq.org/doc/latest/manual/sql-building/plain-sql/ > - Execute Listeners for adding additional clauses to the end of your > statement: > http://www.jooq.org/doc/latest/manual/sql-building/dsl-context/custom-execute-listeners/ > > I hope this helps, > Lukas > > 2015-01-26 17:52 GMT+01:00 Stanimir Marinov <[email protected]>: > >> I need to have order column with MySQL. And its need to write query to >> update this column. >> How can I write this query with JOOQ ? >> >> update mytable cross join (select @rownumber := 0) rset Moneyorder = >> (@rownumber := @rownumber + 1)order by MoneyOrder asc >> >> >> http://stackoverflow.com/questions/10485769/mysql-update-a-column-with-an-int-based-on-order >> >> -- >> 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.
