table using LOAD DATA INFILE
3) I convert all numeric values using
UPDATE TABLE temptable SET numeric_field=REPLACE(numeric_field, ',' ,
'.')
4) I load (or append) data from temporary table into main table.
Petr Vileta
http://www.zivnosti.cz
http://www.practisoft.cz
--
MySQL General Mailing
| | |
+--++--+-+-+---+
Test to use varchar(5) binary field type for CYSYMBOL field (if you store
symbols here).
Petr Vileta, Czech republic
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
I have mysql 3.23.55 for Windows where charset win1250ch is included. Now
I download the same version for Linux (rpm) but this charset is not included
here. Why?
Thank you for your quick reply.
Petr Vileta, Czech Republic
http://www.practisoft.cz