mySQL parameterized querues - resetting the parameter


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?


  • RobertPenridge

    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.