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
echo $1
(of course, without line wrap)
Results of running this script:
[ms@sh test]$ ./test 11111
11111
{REMARK - O'K}
[ms@sh test]$ ./test Test
ERROR 1054 at line 1: Unknown column 'Test' in 'field list'
Test
In another words,there are normal work only with numerical
data, but not with text. When there are text value, she understand
it as the name of column!!!
Version of mySQL is 3.22.32
Format of column 'Textfield' is mediumtext (2). The placing of
any text data into this database via kmysqladmin is normal
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
