Hallo Jigal,
Op 22 Jun 05 schreef Jigal van Hemert aan <[EMAIL PROTECTED]:
JvH> What about reading the data into the table and storing the
JvH> 'amount' in varchar for now. Then you can run an update query in
JvH> UPDATE `table` SET `amount`= REPLACE( `v_amount`, ',' , '.'),
JvH> `v_amount` = NULL WHERE `v_amount` IS NOT NULL;
Perfect! Thank you very much.
Groetjes,
Hans.
jdh punt beekhuizen bij duinheks punt xs4all punt nl
--- GoldED+/LNX 1.1.5/040412
* Origin: The Wizard is using MBSE/Linux (2:280/1018)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
