union works fine but with union 'into outfile' doesn't work anyway mysql ver is 4.0.14
thanx for ur time anyway Nitin ----- Original Message ----- From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 4:12 PM Subject: Re: how to export data from multiple tables > "Nitin" <[EMAIL PROTECTED]> wrote: > > > > I've got a small problem (hope it's very small). Could any of you suggest me how to select my data into a simple text file from multiple tables (selected with union)! > > > > I've tried: > > > > select field-list into outfile filename from table1 > > union > > select field-list into outfile filename from table2 > > union > > select field-list into outfile filename from table3 > > > > It says check your version manual....blah blah > > > > What is the version of MySQL server? UNION is supported from 4.0. > > > -- > 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]
