On Monday 22 March 2004 18:26, Shane Nelson wrote: > Thanks, the help file cleared up the rest. > > In my case the table tt wasn't a merge table, it was just a table I > created normally. Even so the alter table line didn't create an error.
If the table type other than MERGE, UNION part of the ALTER TABLE statement is ignored. So, your ALTER TABLE statement will recreate table tt and copy data. > > Shane > > Egor Egorov wrote: > > Shane Nelson <[EMAIL PROTECTED]> wrote: > >>Any idea what this would do? > >> > >>alter table tt union=(t1,t2,t3); > > > > With this statement you specify that MERGE table tt will union tables t1, > > t2, t3 and they will used as one: http://www.mysql.com/doc/en/MERGE.html > > > >>The four tables are all the same and all contain data. I posted the > >>details (schema, contents) of the tables here: > >> > >>http://nopaste.php.cd/10918 > >> > >>I'm running mysql Ver 11.18 Distrib 3.23.58, -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
