Re: ~BCP for mysql~

2006-03-22 Thread Prasanna Raj
Try Using  Select into outfile 

More Info : http://dev.mysql.com/doc/refman/5.0/en/select.html

--Praj

On Wed, 22 Mar 2006 12:59:44 +0530
Mohammed Abdul Azeem [EMAIL PROTECTED] wrote:

 Hi,
 
 Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not,
 is there any other tool which can do the same operation. I need to
 perform a bcp out from Mysql and then bcp in to Sybase. Please help
 me out regarding the same.
 
 Thanks in advance,
 Abdul.
 
 
 This email has been Scanned for Viruses!
   www.newbreak.com
 
 
 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



~BCP for mysql~

2006-03-21 Thread Mohammed Abdul Azeem
Hi,

Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not,
is there any other tool which can do the same operation. I need to
perform a bcp out from Mysql and then bcp in to Sybase. Please help
me out regarding the same.

Thanks in advance,
Abdul.


This email has been Scanned for Viruses!
  www.newbreak.com



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: ~BCP for mysql~

2006-03-21 Thread Douglas Sims

Try SELECT INTO OUTFILE...

Here's the MySQL documentation on that: http://dev.mysql.com/doc/ 
refman/5.0/en/select.html


Good luck!



On Mar 22, 2006, at 1:29 AM, Mohammed Abdul Azeem wrote:


Hi,

Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If  
not,

is there any other tool which can do the same operation. I need to
perform a bcp out from Mysql and then bcp in to Sybase. Please  
help

me out regarding the same.

Thanks in advance,
Abdul.


This email has been Scanned for Viruses!
  www.newbreak.com



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


Douglas Sims
[EMAIL PROTECTED]




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: ~BCP for mysql~

2006-03-21 Thread Ehrwin Mina

Hi,

You can try to use the command select into outfile.

thanks,

ehrwin


At 03:29 PM 3/22/2006, Mohammed Abdul Azeem wrote:

Hi,

Can we any use bcp to perform bulk copy for MYSQL as in SYBASE ? If not,
is there any other tool which can do the same operation. I need to
perform a bcp out from Mysql and then bcp in to Sybase. Please help
me out regarding the same.

Thanks in advance,
Abdul.


This email has been Scanned for Viruses!
  www.newbreak.com



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Ehrwin C. Mina

Chikka Phils. Inc.

A CMMI LEVEL 5,
AND A ISO 9001:2000; ISO 15000:2002; ISO 17799:2002 CERTIFIED COMPANY


This message and any attachment are confidential and may be 
privileged or otherwise protected from disclosure. If you are not the 
intended recipient, you must not copy this message or attachment or 
disclose the contents to any other person. If you have received this 
transmission in error, please notify the sender immediately and 
delete the message and any attachment from your system. Chikka does 
not accept liability for any omissions or errors in this message 
which may arise as a result of E-Mail-transmission or for damages 
resulting from any unauthorized changes of the content of this 
message and any attachment thereto. Chikka does not guarantee that 
this message is free of viruses and does not accept liability for any 
damages caused by any virus transmitted therewith.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]