Re: mysqldump issues

[Ed Carp]

daniel james ([EMAIL PROTECTED]) writes:

 I need to generate a tab-delimited text dump of table
 data ONLY and have it output to a text file. I don't
 want any table info, delimiters, etc.  I need this to
 copy/paste into a excel spreadsheet.  What's the
 syntax?
 
 I'm stuck here:
 
 % mysqldump dbname tablename  ???

Easier:

echo select * into outfile 'tablename.tsv' from tablename|mysql dbname
--
Ed Carp, N7EKG  -  [EMAIL PROTECTED]  -  214/341-4420 - http://www.pobox.com/~erc

Squished Mosquito, Inc.
Internet Applications Development
Escapade Server-Side Scripting Language Development Team
http://www.squishedmosquito.com
Pensacola - Dallas - Dresden - London

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysqldump issues

[Tomas Carmen]

daniel james wrote:
 
 I need to generate a tab-delimited text dump of table
 data ONLY and have it output to a text file. I don't
 want any table info, delimiters, etc.  I need this to
 copy/paste into a excel spreadsheet.  What's the
 syntax?
 
 I'm stuck here:

Hi: 
What do you think about: 

select fields from table  into outfile 'file' 
  


 
 % mysqldump dbname tablename  ???
 
 pleasepleaseplease help..!
 
 __
 Do You Yahoo!?
 
-- 
Tomas Carmen R.
TCC S.A.
telef.:+51-1-4428842
fax  : +51-1-4426434

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php