解决Data truncated for column 'content' at row 1

 

1.show variables like '%sql_mode%';

 

2.set sql_mode='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

 

3.load data infile 'F:\\u1.test' into table pp_1(user_id,movie_id,score,datetime);