mySQL parameterized querues - resetting the parameter

user10110

I setup a parameterized query that pulls just incremental data based on IDs.

 

I initially set the parater to zero and on the first pull it retrieved all rows as expected.  On subsequent runs it's pulling just the new records as expected.

 

Is there a way to 'reset' the parameter so that will will re-pull all rows in the table?

user10110

The only solution I could figure out was to adjust the SQL so that my `id` field had a hardcoded value of zero, ie...

 

select 0 as id from mytable...

 

That way the internally remembered value became zero.  I then reverted the SQL to the original settings.