Kittiphum,
Saturday, November 30, 2002, 2:09:00 AM, you wrote:
KW> Why merge table have been done with table that have column char type
KW> not varchar type.
KW> Have anyone succesfully with varchar type merge table and how to do
KW> that.
KW> And how to use union query if merge table not work with varchar or
KW> what SQL to use for convert varchar back to char
It works perfectly well for me:
mysql> create table t1(name varchar(10));
Query OK, 0 rows affected (0.01 sec)
mysql> create table t2(name varchar(10));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into t1 values('aa'),('bb');
Query OK, 2 rows affected (0.01 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> insert into t2 values('cc'),('dd');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> create table total(name varchar(10)) TYPE=MERGE UNION=(t1, t2);
Query OK, 0 rows affected (0.01 sec)
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
