From: Fred van Engen
Date: February 16 2001 12:15pm
Subject: Re: Bug report
List-Archive: http://lists.mysql.com/mysql/65483
Message-Id: <20010216131517.E12904@nl.xo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

On Fri, Feb 16, 2001 at 02:35:20PM +0300, Афанасьев Г.Л. wrote:
> 
> The test script is a command that must place test value into a column
> in the table. Syntaxis - ./test <placed-value>. Text of script:
> 
> #! /bin/bash
> /usr/bin/mysql --user=**** --password=**** --host=localhost
> --port=3306 --execute='INSERT INTO TableName SET TextField='$1''
> DatabaseName
> 

I think you're having some problems with shell quoting. Try:

/usr/bin/mysql --user=**** --password=**** --host=localhost
--port=3306 --execute="INSERT INTO TableName SET TextField='$1'"
DatabaseName

or:

/usr/bin/mysql --user=**** --password=**** --host=localhost
--port=3306 "--execute=INSERT INTO TableName SET TextField='$1'"
DatabaseName


Regards,

Fred.

-- 
Fred van Engen                              XO Communications B.V.
email: fred.van.engen@stripped             Televisieweg 2
tel: +31 36 5462400                         1322 AC  Almere
fax: +31 36 5462424                         The Netherlands