MySQL Forums
Forum List  »  General

Re: MySQL 8.0 LOAD DATA INFILE error 1265 Truncated column
Posted by: Peter Brawley
Date: November 18, 2019 11:00AM

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.

Options: ReplyQuote




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.