List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 3 2001 2:37am
Subject:Re: specifying a delimiter
View as plain text  
At 9:11 PM -0500 5/2/01, Paul DuBois wrote:
>At 10:01 AM -0500 5/2/01, admin@stripped wrote:
>>Hi,
>>Being new to MySQL, I am having a problem getting output from it to the
>>shell that is formatted the way I need.  I need a table to be written to a
>>file with a delimiter.
>>something like :
>>
>>#!/bin/sh
>>mysql -uroot -ptest database < sql
>>
>>Then I run that script like this:
>>./script.sh > output.txt
>>
>>Any delimiter is ok except for tab.  Is this possible?
>>Thanks, in advance,
>
>
>Not with mysql by itself.  You can use sed or tr to change
>the tab in mysql's output to something else.  The syntax for
>tr varies among systems, but on one of my systems (RedHat),
>both of these work:
>
>mysql .... < sql | tr '\t' :
>
>mysql .... < sql | tr '\011' :
>
>--
>Paul DuBois, paul@stripped

Er, I should have been more specific and said "both of these work to
change tabs to colons".  Substitute whatever other character you wish.
Sorry.

-- 
Paul DuBois, paul@stripped
Thread
MySQL can't open mysql.sock on startChad Nantais2 May
  • Re: MySQL can't open mysql.sock on startGerald Clark2 May
    • specifying a delimiteradmin2 May
      • Re: specifying a delimiterPaul DuBois3 May
        • Re: specifying a delimiterPaul DuBois3 May
          • RE: specifying a delimiteradmin4 May
            • RE: specifying a delimiterPaul DuBois4 May
              • space in column name and table name, standard?.Mohamad Ilhami4 May
                • Re: space in column name and table name, standard?.Rolf Hopkins4 May
                • Re: space in column name and table name, standard?.Van4 May
            • RE: specifying a delimiterDon Read4 May