Tuesday, June 6, 2017

data truncation data too long for column at row 1 in mysql

Problem - data truncation data too long for column at row 1 in mysql

Hey,
This error appears because,the size to data you tried to insert into column is too large.

Solution - Change the column size to max.Assuming your column is of type VARCHAR,then in mySQL

ALTER TABLE table_name CHANGE COLUMN col_name col_name VARCHAR(1000); //assuming 1000 is enough

No comments:

Post a Comment