Dear all,
I know that there is a MERGE engine in mysql.
It's great.
I want to know is there a way to make new log tables and new merge table
based on some criteria.
Let me explain more with an example.
I have a log_2004_09_01 table and a MERGE table on it called log.
I want to automatically make log_2004_10_01 table and update log table to
use log_2004_10_01 too.

Is it possible by mysql itself without scripting?
else how can I tell mysql to keep incoming queries till the script does
this?

--
Sincerely,
Hadi Rastgou
A Google Account is the key that unlocks the world of Google.
<a href= "http://www.spreadfirefox.com/?q=affiliates&amp;id=0&amp;t=1"> Get
FireFox! </a>