/* Warning (1265): Data truncated for column '' at row 11 */

[expired user #8537]'s profile image [expired user #8537] posted 9 years ago in General Permalink

Hi, I created an Excel spreadsheet with various columns. Among the various there are dates and I set the cell format as "date" .. then be imported into HeidiSQL I created the file csv comma-separated. The various columns correctly import the data (set varchar 255), but the dates gives me the error "/ * Warning (1265): Data truncated for column 'ADATA' at row 11 * /" I set the column value "dates "," datetime "and" varchar "but always returns the same error. How can I fix this? thanks
ansgar's profile image ansgar posted 9 years ago Permalink
Please post an excerpt of your csv file here, with some of these non-working date values. Also, post the LOAD DATA command here.
[expired user #8537]'s profile image [expired user #8537] posted 9 years ago Permalink
LOAD DATA LOW_PRIORITY LOCAL INFILE 'C:\\Users\\sitro2\\Desktop\\FlussoSDO2013mysqlDATE.csv' INTO TABLE `hsm_xxxx`.`flussosdo2013` FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\r\n' IGNORE 1 LINES (`COGNOME`, `NOME`, `NDATA`, `COMNAS`, `ETA`, `CODSAN`, `CODFIS`, `SESSO`, `STACIV`, `REG`, `comdes`, `COMRES`, `compro`, `comusl`, `CIT`, `nazione`, `nazdes`, `CC`, `drg`, `mdc`, `tip`, `des`, `ADATA`, `PDATA`, `TIPORIC`, `TRAUMA`, `DDATA`, `AUTOPSIA`, `IDATA`, `LOS2`, `GIOAMM`, `GIODIM`, `DIAP`, `DESDIAP`, `DIA1`, `DESDIA1`, `DIA2`, `DESDIA2`, `DIA3`, `DESDIA3`, `DIA4`, `DIA5`, `INTP`, `DESINTP`, `INT1`, `DESINT1`, `INT2`, `DESINT2`, `INT3`, `INT4`, `INT5`, `desintes`, `rep`, `desc`);
/* 30.294 rows imported in 27,908 seconds. */
SHOW WARNINGS;
/* Warning (1265): Data truncated for column 'NDATA' at row 1 */
/* Warning (1265): Data truncated for column 'DDATA' at row 1 */
/* Warning (1366): Incorrect string value: '\xD9' for column 'DESINTP' at row 1 */
/* Warning (1265): Data truncated for column 'NDATA' at row 2 */
/* Warning (1265): Data truncated for column 'DDATA' at row 2 */
ansgar's profile image ansgar posted 9 years ago Permalink
Where's the csv sample rows?
[expired user #8537]'s profile image [expired user #8537] posted 9 years ago Permalink
past jpg file excel here?
ansgar's profile image ansgar posted 9 years ago Permalink
Not a screenie from excel, I need to see the raw data. Plain text please.

Please login to leave a reply, or register at first.