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&id=0&t=1"> Get FireFox! </a>