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);
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);