在命令行（cmd）中操作

啟動(dòng)cmd

進(jìn)入MySQL安裝路徑

使用如下命令登錄(這里是為了獲得權(quán)限)：

mysql --local-infile=1 -u root -p

登陸成功后，選擇進(jìn)入數(shù)據(jù)庫并查看是否有導(dǎo)入外部數(shù)據(jù)的權(quán)限

mysql> use test; mysql> show global variables like 'local_infile'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | local_infile | OFF | +---------------+-------+

打開導(dǎo)入外部數(shù)據(jù)的權(quán)限

mysql> set global local_infile = 'ON'; mysql> show global variables like 'local_infile'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | local_infile | ON | +---------------+-------+

然后再進(jìn)行數(shù)據(jù)導(dǎo)入（emp表結(jié)構(gòu)已創(chuàng)建好）注意關(guān)鍵字local 路徑中不能有中文，’\‘在編程語言中是轉(zhuǎn)義符，因此要改為’\'或‘/’

mysql> load data local infile "C:/Users/EDZ/Desktop/employee.csv"into table emp fields terminated by ',' ignore 1 lines; mysql> select * from emp; +-------+--------+-----------+------+------------+------+------+--------+ | empid | ename | job | mgr | hiredate | sal | comm | deptno | +-------+--------+-----------+------+------------+------+------+--------+ | 7369 | smith | clerk | 7902 | 1980-12-17 | 800 | NULL | 20 | | 7499 | allen | salesman | 7698 | 1981-02-20 | 1600 | 300 | 30 | | 7521 | ward | salesman | 7698 | 1981-02-22 | 1250 | 500 | 30 | | 7566 | jones | manager | 7839 | 1981-04-02 | 2975 | NULL | 20 | | 7654 | martin | salesman | 7698 | 1981-09-28 | 1250 | 1400 | 30 | | 7698 | blake | manager | 7839 | 1981-05-01 | 2850 | NULL | 30 | | 7782 | clark | manager | 7839 | 1981-06-09 | 2450 | NULL | 10 | | 7788 | scott | analyst | 7566 | 1987-04-19 | 3000 | NULL | 20 | | 7839 | king | persident | NULL | 1981-11-17 | 5000 | NULL | 10 | | 7844 | turner | salesman | 7698 | 1981-09-08 | 1500 | 0 | 30 | | 7876 | adams | clerk | 7788 | 1987-05-23 | 1100 | NULL | 20 | | 7900 | james | clerk | 7698 | 1981-12-03 | 950 | NULL | 30 | | 7902 | ford | analyst | 7566 | 1981-12-03 | 3000 | NULL | 20 | | 7934 | miller | clerk | 7782 | 1982-01-23 | 1300 | NULL | 10 | +-------+--------+-----------+------+------------+------+------+--------+

這里要特別注意的是emp.csv文件不是我們在emp文件后面簡單加個(gè).csv后綴就行，而是打開emp文件將其另存為.csv文件

如果我們只是簡單加個(gè).csv后綴，如下圖，那么在導(dǎo)入的時(shí)候就會(huì)出現(xiàn)錯(cuò)誤

ERROR 29 (HY000): File 'C:/Users/EDZ/Desktop/employee.csv' not found (OS errno 2 - No such file or directory)

我主要是最后一個(gè)問題ERROR 29 (HY000): File 'C:/Users/EDZ/Desktop/employee.csv' not found (OS errno 2 - No such file or directory)導(dǎo)致我浪費(fèi)了很多多時(shí)間，以下原來最后一個(gè)問題之前的內(nèi)容，我僅僅對最后一個(gè)問題進(jìn)行自己的解決方法，希望幫到大家。

原文鏈接：https://blog.csdn.net/kejiayuan0806/article/details/103170790

總結(jié)

以上是生活随笔為你收集整理的MySQL8.0导入数据的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。