What machines are you working with at each end? Internal network? -----Original Message----- From: Nitin [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 08, 2003 10:19 AM To: Andy Eastham; Mysql List Subject: Re: how to export data from multiple tables
any idea, how to export data to a file on the remote machine? thanx for the help anyway Nitin ----- Original Message ----- From: "Andy Eastham" <[EMAIL PROTECTED]> To: "Mysql List" <[EMAIL PROTECTED]> Sent: Tuesday, October 07, 2003 9:49 PM Subject: RE: how to export data from multiple tables > 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] > -- 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]