RE: Merge tables, was [two table's columns into one columns w/o INSERT ... SELECT?]

2002-05-06 Thread Jay Blanchard 

I have these two tables;
mysql describe tblClass11;
+--+---+--+-+-++
| Field| Type  | Null | Key | Default | Extra  |
+--+---+--+-+-++
| ID   | int(11)   |  | PRI | NULL| auto_increment |
| RecordID | varchar(6)| YES  | | NULL||
| RecordDate   | varchar(10)   | YES  | | NULL||
| CIC  | varchar(4)| YES  | | NULL||
| Minutes  | decimal(12,2) | YES  | | NULL||
| FileName | varchar(32)   | YES  | | NULL||
| RecordNumber | int(11)   | YES  | | NULL||
| WholeRecord  | text  | YES  | | NULL||
| ReceivedDate | varchar(10)   | YES  | | NULL||
+--+---+--+-+-++
9 rows in set (0.00 sec)

mysql describe tblClassOthers;
+--+---+--+-+-++
| Field| Type  | Null | Key | Default | Extra  |
+--+---+--+-+-++
| ID   | int(11)   |  | PRI | NULL| auto_increment |
| RecordID | varchar(6)| YES  | | NULL||
| RecordDate   | varchar(10)   | YES  | | NULL||
| CIC  | varchar(4)| YES  | | NULL||
| Minutes  | decimal(12,2) | YES  | | NULL||
| FileName | varchar(32)   | YES  | | NULL||
| RecordNumber | int(11)   | YES  | | NULL||
| WholeRecord  | text  | YES  | | NULL||
| ReceivedDate | varchar(10)   | YES  | | NULL||
+--+---+--+-+-++
9 rows in set (0.00 sec)

I attempt to MERGE;
mysql CREATE TABLE tblCross1 (ID INT NOT NULL,
- RecordID VARCHAR(6),
- RecordDate VARCHAR(10),
- Minutes DECIMAL(12,2),
- KEY(ID))
- TYPE=MERGE
- UNION=(tblClass11, tblClassOthers);
Query OK, 0 rows affected (0.01 sec)

Then I attempt to query;mysql select count(*) from tblCross1;
ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143)
perror 143
143 = Conflicting table definition between MERGE and mapped table

Can anyone help with this?

Thanks!
Jay




-
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

RE: Merge tables, was [two table's columns into one columns w/o INSERT ... SELECT?]

2002-05-06 Thread Jay Blanchard 

[snip]
Then I attempt to query;mysql select count(*) from tblCross1;
ERROR 1016: Can't open file: 'tblCross1.MRG'. (errno: 143)
perror 143
143 = Conflicting table definition between MERGE and mapped table

Can anyone help with this?

Drop the MERGE table, then try creating it with all the columns
in the original tables.
[/snip]

OK, that work with two of the tables, I have to merge 3. Is that possible?

Do the INDEXES have to exist on the same columns in each table? How
identical do the tables have to be?

Thanks!

Jay

P.S. Paul, couldn't help but notice your last name, where are you from?



-
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