Am Donnerstag, 6. November 2003 13:14 schrieb Bernd Tannenbaum: > Hi all, > only small problem here (me hopes). > I update a field with a value that is stored in a bash-variable. > The value in the variable ($dsvar2) is like "000012.0000". > So what i want is to keep the leading and trailing "0" in the value. > > in the bash-scipt: > /mysql -e "UPDATE table > SET field=$dsvar2 WHERE id=$i" db --password=xx;
Ok, my mistake..... Set field='$dsvar2' This way the string is written completely, "Text" as field type works. Thx, Bernd -- One OS to rule them all, one OS to find them. One OS to bring them all, and in the darkness bind them In the land of Redmond, where the shadows lie. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
