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.

>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 !!

The *view* changes or the *data* in the base table changes?
A view does not copy a bunch of data. A view is a query, and
changing a view involves changing the query.

>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??

Something like:
select * from v_spectacles;
will return up-to-date data from the base table, whenever you run it.


>or this will not be dynamicaly refresh?

There isn't any operation "refresh" on a view.

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 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.
>
>
>