Hi all,

I create a viewfor spectacles

create view v_spectacles as

select Sname,Sdate,Scategory,...
from spectacles

Where Sdate > now()

this view will change every day !!
But how does mysql refresh it. Is it a cron task, and how many time is
it launched?? which frequency, how to modify the frequency??

or this will not be dynamicaly refresh?

thx for suggestions.