Hello,
This is currently not supported in jOOQ. I have registered a feature
request for this:
https://github.com/jOOQ/jOOQ/issues/2558
I'm not sure how much support for variables can really be added to jOOQ in
a useful way. But in any case, you can always resort to plain SQL:
DSL.field("@outerval:=@outerval+1");
DSL.field("@outerval");
Cheers
Lukas
2013/6/26 Syed Shahul <[email protected]>
>
> Hey,
>
> What is the Jooq equivalent of Mysql variable in select statement.
>
> CASE WHEN (date IS NULL) THEN (*@outerval:=@outerval+1*) ELSE (@outerval)
> END AS consec_set
>
> Regards,
> Shahul.
>
> --
> 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/groups/opt_out.
>
>
>
--
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/groups/opt_out.
