I need to have order column in my table and update the order. How to write with JOOQ this MySQL query?
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.
