将CSV文件导入/导出MySQL

CSV导入MySQL教程

最新推荐文章于 2024-05-14 01:05:15 发布

原创最新推荐文章于 2024-05-14 01:05:15 发布 · 318 阅读

0 ·

CC 4.0 BY-SA版权

数据库专栏收录该内容

7 篇文章

订阅专栏

本文介绍如何使用MySQL的LOAD DATA INFILE命令将CSV文件导入到数据库表中，包括指定字段分隔符、字符串引用符号及转义字符等配置。

csv导入mysql

load data infile 'C:\\Users\\UserName\\Desktop\\test.csv' 
into table `table` 
fields terminated by ',' optionally enclosed by '"' escaped by '"' 
lines terminated by '\n';

mysql导入csv

select * from `table`
load data infile 'C:\\Users\\UserName\\Desktop\\test.csv' 
fields terminated by ',' optionally enclosed by '"' escaped by '"' 
lines terminated by '\n';