MySQL sub query with variable

Question

How to pass a MySQL variable to a sub query something like as illustrated below.

select
 v.val, @var:= @var + 1 var 
from 
 (select val from table where id=@var) v, 
 (select @var:= 0) var

Jay Shankar Gupta · Accepted Answer · 2018-04-11 09:52:45Z

1

select
 v.val ,var
from 
(select val, @var:= @var + 1 var from Table1,(select @var:= 0) var where id=@var+1) v

Demo

http://sqlfiddle.com/#!9/765e9c/14

answered Apr 11, 2018 at 9:52

Jay Shankar Gupta

6,1281 gold badge14 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mpsbhat Over a year ago

What if there are two tables say table1 and table2? Means, something like

select  v1.val1, v2.val2, @var:= @var + 1 var  from   (select val1 from table1 where id=@var) v1,  (select val2 from table2 where id=@var) v2,  (select @var:= 0) var

Collectives™ on Stack Overflow

MySQL sub query with variable

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related