List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 3 2001 2:11am
Subject:Re: specifying a delimiter
View as plain text  
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
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