Home > Database > Mysql Tutorial > body text

mysql中的Load data的使用方法_MySQL

WBOY
Release: 2016-06-01 13:23:39
Original
1079 people have browsed it

bitsCN.com 测试把txt文件导入至mysql数据库中:

table:


txt文件:D:/data.txt (txt文件下载)

txt中使用 '/N' 描述null值。

导入数据:


load data local infile 'D:/data.txt' into table pet
lines terminated by '/r/n' ignore 1 lines;


应用mysql版本:

bitsCN.com
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template