2021-02-17
閱讀量:
2903
MYSQL無(wú)法導(dǎo)入數(shù)據(jù)
我的MYSQL導(dǎo)入數(shù)據(jù)時(shí)會(huì)報(bào)錯(cuò),網(wǎng)上找了很多博客,都讓修改my.ini文件中的這個(gè)'secure_file_priv',的路徑,但是我修改了以后發(fā)現(xiàn)并沒(méi)有變換,并且將文件放入到安全路徑進(jìn)行導(dǎo)入依然不行,有沒(méi)有大神知道到底是啥問(wèn)題呀
load data infile'C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\t1.csv' into table t1 fields terminated by ',' ignore 1 lines; Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement






評(píng)論(3)

CDA考試動(dòng)態(tài)
CDA報(bào)考指南
推薦帖子
0條評(píng)論
1條評(píng)論
0條評(píng)論