can u suggest any workaround? anyway thanx for help Nitin
----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 8:32 PM Subject: Re: how to export data from multiple tables > "Nitin" <[EMAIL PROTECTED]> wrote: > > union works fine but with union 'into outfile' doesn't work > > UNION with SELECT .. INTO OUTFILE works from version 4.1 > > mysql> SELECT * FROM t1 UNION SELECT * FROM t2 INTO OUTFILE '/tmp/tmp.txt'; > Query OK, 4 rows affected (0.00 sec) > > > > > > anyway mysql ver is 4.0.14 > > > > thanx for ur time anyway > > Nitin > > > > ----- Original Message --- > > -- > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
