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; But the field in the db only shows "12" not "000012.0000". So i guess it depends on the type of field i have defined. Me tried text, char, varchar and some other but none seems to keep the "0" `s. Can u gimme a hint, what type of field i need to look for? All help welcome, 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]
