If I create a merge table:
---snip---
CREATE TABLE mytable0 (
a INTEGER NOT NULL PRIMARY KEY,
b CHAR(18) NOT NULL
);
CREATE TABLE mytable1 (
a INTEGER NOT NULL PRIMARY KEY,
b CHAR(18) NOT NULL
);
CREATE TABLE mytable2 (
a INTEGER NOT NULL PRIMARY KEY,
b CHAR(18) NOT NULL
);
CREATE TABLE mytable (
a INTEGER NOT NULL PRIMARY KEY,
b CHAR(18) NOT NULL
) TYPE = MERGE UNION = (mytable0, mytable1, mytable2) INSERT_METHOD =
LAST;
---snip---
and then look at the table status:
---snip---
mysql> show table status like 'mytable' \G
*************************** 1. row ***************************
Name: mytable
Type: MRG_MyISAM
Row_format: Fixed
Rows: 2
Avg_row_length: 23
Data_length: 46
Max_data_length: NULL
Index_length: 0
Data_free: 0
Auto_increment: NULL
Create_time: NULL
Update_time: NULL
Check_time: NULL
Create_options:
Comment:
1 row in set (0.01 sec)
---snip---
The create time is NULL. Why? Can it not be deduced from the
timestamp on mytable.MRG?
I don't see this documented anywhere.
The underlying tables, of course, have that information:
---snip---
mysql> show table status like 'mytable2' \G
*************************** 1. row ***************************
Name: mytable2
Type: MyISAM
Row_format: Fixed
Rows: 2
Avg_row_length: 23
Data_length: 46
Max_data_length: 98784247807
Index_length: 2048
Data_free: 0
Auto_increment: NULL
Create_time: 2002-02-25 21:53:21
Update_time: 2002-02-25 21:54:37
Check_time: NULL
Create_options:
Comment:
1 row in set (0.00 sec)
---snip---
Thanks,
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.47-max: up 18 days, processed 584,328,760 queries (361/sec. avg)
---------------------------------------------------------------------
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
