1 . 远程导入加 LOCAL LOAD DATA LOCAL INFILE "C:/MyDocs/SQL.txt" INTO TABLE Orders fields terminated by ',' LINES TERMINATED BY '/r/n' ; 2. 向指定的栏目(field)中导入数据: LOAD DATA INFILE "/home/Order.txt" INTO TABLE Orders(Order_Number, Order_Date, Customer_ID); 导入文件的编码要和数据库的编码一致 |
mysql 导入csv 文件
最新推荐文章于 2022-06-08 17:44:39 发布