On Fri, Feb 16, 2001 at 05:58:27PM +0300, Peter Zaitsev wrote:
> Hello monty,
>
> I'm trying to use merge table for logging - to have a possibility to
> Rotate log files and to quickly delete old data - for this I'm goint
> to setup a number of merge tables where each contains data for one
> day, and the inserts are done to the last table using real table
> name, therefore the select runs on merged table to cover all data.
>
Great. I'm trying something similar.
> Let's add the key:
>
> mysql> alter table t2 add key(val);
> Query OK, 2 rows affected (0.00 sec)
> Records: 2 Duplicates: 0 Warnings: 0
>
Merge tables should have the same definition as the tables underneath.
I believe that this includes having identical indexes. Maybe someone
can confirm this?
Here you have just made one of the tables underneath different from
the other and from the merge table.
You may want to read the discussion in the MySQL bugs list about
merge tables. There are two threads but the discussion shifted into
one of them.
Regards,
Fred.
--
Fred van Engen XO Communications B.V.
email: [EMAIL PROTECTED] Televisieweg 2
tel: +31 36 5462400 1322 AC Almere
fax: +31 36 5462424 The Netherlands
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
