[EMAIL PROTECTED]
To: 'Nitin' [EMAIL PROTECTED]; Mysql List
[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 10:00 PM
Subject: RE: how to export data from multiple tables
What machines are you working with at each end? Internal network?
-Original Message-
From: Nitin [mailto:[EMAIL
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
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
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
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
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
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
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
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