How to set input property of 'Query' node?
Posted: 22 Sep 2017, 04:50
Hi, guys
This is the 'teacher' table below:
--------------------------------------
id | name | course
--------------------------------------
1 | tcr_nash | math
--------------------------------------
2 | tcr_bruno | chemistry
--------------------------------------
3 | tcr_smith | physics
--------------------------------------
My query statement is:
SET @c = 'math';
SELECT name FROM teacher WHERE course = @c;
As my understanding for 'Query' node, I set @c as the input property, but I can't get any result. Why?
Thanks,
YMY
This is the 'teacher' table below:
--------------------------------------
id | name | course
--------------------------------------
1 | tcr_nash | math
--------------------------------------
2 | tcr_bruno | chemistry
--------------------------------------
3 | tcr_smith | physics
--------------------------------------
My query statement is:
SET @c = 'math';
SELECT name FROM teacher WHERE course = @c;
As my understanding for 'Query' node, I set @c as the input property, but I can't get any result. Why?
Thanks,
YMY