One of the purposes of a VIEW is to disguise compexity of queries .
So, you wouldn't necessarily use a VIEW for every query
--
Jack Vamvas
___________________________________
Search IT jobs from multiple sources-
http://www.ITjobfeed.com/mySQL
"Séverin Richard" <severin.richard@free.fr> wrote in message
news:46f50853$0$24333$426a74cc@news.free.fr...
> Hi all,
>
> I create a view
for 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.
>
>
>