i want to select only new entries , and i am gonna use last sql value ,
but in my case i am wokring on shops , so i have two dates , date of creation ( if somebody buy something ) and date of modification ( if somebody buy something and change it after few days )
so in this case i can't put my date of creation > sql last value ,
if i concatenate the date of creation and date last modification can give me a new value that can i track ?
The tracking column has to be numeric or a timestamp. What you suggested would be neither. Maybe you could sort your query by
GREATEST( creation_date, modification_date) and also use that as a tracking column?
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.