Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
5.5.32-galera
-
None
-
None
-
None
-
Windows, working with HeidiSQL
Description
I'm importing millions of numbers into a database using:
LOAD DATA LOCAL INFILE 'filename' |
INTO Table 'tablename' |
Fields terminated by ';' |
Lines terminated by '\r'; |
The numbers are mostly formatted like: 8,70840419842013E-03.
I am importing into a 'FLOAT not null' field. The database converts the input to '8' instead of '0.00870840419842013'.
New to MariaDB (and creating issues on this board) so please be gentle or give me tips on how to improve this issue. If this should be filed differently, please let me know.