On Thursday 12 January 2006 12:47 pm, Jake Peavy wrote:
> On 1/12/06, Mark Phillips <[EMAIL PROTECTED]> wrote:
>
> > There is a column in my table with string values, but the strings have
> > spaces
> > in them. I want to read the unique column values into an array in my bash
> > script, so I can
quot;${TEAM_QUERY}"|sed 's/^/"/g'|sed 's/$/"/g'`)
Commas are not used in the definition of an array - just spaces between quoted
strings.
Thanks for your help!
>
>
>
>
>
> -Original Message-
> From: Mark Phillips [mailto:[EM
On 1/12/06, Mark Phillips <[EMAIL PROTECTED]> wrote:
> There is a column in my table with string values, but the strings have
> spaces
> in them. I want to read the unique column values into an array in my bash
> script, so I can use these values in a separate query on this table. How
> do I
> get
: Thursday, January 12, 2006 12:44 PM
To: MYSQL List
Subject: Question regarding running 'mysql' from a bash script
There is a column in my table with string values, but the strings have
spaces
in them. I want to read the unique column values into an array in my
bash
script, so I
one answer to your question as asked would be to wrap the column in a
concat() function and put the double quotes around each row.
the better answer is to use PERL
Oops - I forgot my version of mysql - 4.0.22 running on Red Hat Linux 7.3
2.96-113 kernel 2.4.20-30.7.
Mark
On Thursday 12 January 2006 10:43 am, Mark Phillips wrote:
> There is a column in my table with string values, but the strings have
spaces
> in them. I want to read the unique column val
There is a column in my table with string values, but the strings have spaces
in them. I want to read the unique column values into an array in my bash
script, so I can use these values in a separate query on this table. How do I
get the values into an array?
For example, the column teams in my