-
Hi
Lackó
mailto:[EMAIL PROTECTED]
- Original Message -
From: "Hanzsek Laszlo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 12:24 PM
Subject: Temporary merge table
> I want to creat
I want to create a temporary merge table:
CREATE TABLE 42_t1 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20))
CREATE TABLE 42_t2 (a INT AUTO_INCREMENT PRIMARY KEY, message CHAR(20))
CREATE temporary TABLE 42_merge_temp (a INT NOT NULL, message CHAR(20),
KEY(a)) TYPE=MERGE UNION=(42_t1,42_t2)