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.
