Nitin, Create a temporary table, then select each table into it in turn, then output that to the file?
Andy > -----Original Message----- > From: Nitin [mailto:[EMAIL PROTECTED] > Sent: 07 October 2003 11:40 > To: [EMAIL PROTECTED] > Subject: how to export data from multiple tables > > > Hi all, > > 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 > > Any idea, how to do it? > > Thanx in advance > Nitin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
