Re: MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column
A picture would be useless. The data is text. All you need to do is post a line or two of the .csv file that fails.
Re your Create Table, use Date and Time columns to store date and time values, and all-upper-case column names just ask for trouble if the system ever runs on a platform other than Windows.
secure-file-priv='' has no effect, set = a value then import & export work only with files in that folder, set to null disables all import & export.
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_secure_file_priv describes defaults in a way I don't find useful.
Subject
Written By
Posted
November 15, 2019 04:56AM
November 15, 2019 08:58AM
November 18, 2019 05:06AM
November 18, 2019 05:11AM
Re: MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column
November 18, 2019 11:00AM
November 19, 2019 06:03AM
November 19, 2019 12:41PM
November 20, 2019 04:31AM
November 20, 2019 12:02PM
November 21, 2019 05:43AM
November 21, 2019 10:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.