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
