List:General Discussion« Previous MessageNext Message »
From:Morning Star Date:October 3 2012 1:35pm
Subject:passing shell variable to the SET data type in parentheses
View as plain text  
Hi guys,
i have a problem when trying to pass shell variable to the SET data
type in parentheses.
i have a variable like this:

$ echo $var
"value1","value2","value3"

what i did:
mysql -u $user -p${password} --skip-column-names -e 'ALTER TABLE
'$table' MODIFY '$kolom' SET(" '$var' ");' $database ;

the result:
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'value1","value2","value3' at line 1

what do i have to do? please help me.

Greetings,

Marco
Thread
passing shell variable to the SET data type in parenthesesMorning Star3 Oct
  • Re: passing shell variable to the SET data type in parenthesesMichael Dykman3 Oct
    • Re: passing shell variable to the SET data type in parenthesesGarot Conklin3 Oct
      • Re: passing shell variable to the SET data type in parenthesesGarot Conklin3 Oct
  • Re: passing shell variable to the SET data type in parentheseshsv4 Oct
    • Re: passing shell variable to the SET data type in parenthesesMorning Star4 Oct