Dave" <[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? I
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
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
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,
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
> "Ni
"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
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:
"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
> selec
