mysql load file写法

最新推荐文章于 2025-01-31 18:28:17 发布

原创最新推荐文章于 2025-01-31 18:28:17 发布 · 506 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mysql

mysql 专栏收录该内容

6 篇文章

订阅专栏

本文详细介绍了如何使用MySQL的LOAD DATA INFILE命令来高效地从本地文件批量导入数据到数据库表中，包括设置字符集、字段分隔符等关键参数的使用方法。

LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE ‘file_name’
[REPLACE | IGNORE]
INTO TABLE tbl_name
[PARTITION (partition_name,…)]
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY ‘string’]
[[OPTIONALLY] ENCLOSED BY ‘char’]
[ESCAPED BY ‘char’]
]
[LINES
[STARTING BY ‘string’]
[TERMINATED BY ‘string’]
]
[IGNORE number {LINES | ROWS}]
[(col_name_or_user_var,…)]
[SET col_name = expr,…]

导入一个值以tab分割的txt文件的例子

mysql --local-infile=1 -uroot -p -Nse"load data local infile '/root/data.txt' into table mydb.mytable character set gbk fields terminated by '\t' ignore 1 lines"