Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ERROR 3948 (42000):进行到csv导入时出问题了 网上所有办法都试过了都没用求解决 #17

Open
BugPu opened this issue Apr 14, 2020 · 1 comment

Comments

@BugPu
Copy link

BugPu commented Apr 14, 2020

image
执行到这一部分指令就报3948,真的没办法了

@BugPu
Copy link
Author

BugPu commented Apr 14, 2020

mysql->CREATE TABLE ratings(userId INT NOT NULL,movieId INT NOT NULL PRIMARY KEY AUTO_INCREMENT,rating DECIMAL(3,1) NOT NULL);
mysql> load data local infile "e:/Moviedatabase/hhhh.csv" into table ratings fields terminated by ','
-> enclosed by '"'
-> lines terminated by '\n'
-> (userId,movieId,rating);

路径我已经改成自己的了 没用

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant