Phpmyadmin cannot read scientific notations in csv file

Asked Oct 30 '17 at 07:38

Active Nov 02 '17 at 00:14

Viewed 119 times

I tried to import my csv file (contains scientific notations) and the system can't read them. Here's what popped out after i tried importing the csv file.

`MySQL said:

1264 - Out of range value for column 'id' at row 1`

That's because the value in column 'id' at row 1 is in scientific notation but mysql read it as decimal. How do i convert the notations automatically?

edited Jun 20 '20 at 09:12

Community

asked Oct 30 '17 at 07:38

Aidel Gerrardo

Can you show us an example of what the lines in your CSV File look like? – Keshpeth Oct 30 '17 at 07:42
Any code sample and csv lines example? – Anton Hlinisty Oct 30 '17 at 07:43
https://drive.google.com/open?id=0B9NjYkwfFlyfZ0FPVjNKV0x4MlE here is the sample datasets – Aidel Gerrardo Oct 30 '17 at 08:49
This seems to be a duplicate of this: https://stackoverflow.com/questions/31547288/importing-data-from-csv-file-into-mysql-scientific-notation Unfortunately, there isn't any answer there. – Isaac Bennetch Nov 02 '17 at 00:14

Phpmyadmin cannot read scientific notations in csv file

1264 - Out of range value for column 'id' at row 1`

0 Answers0