search

Home >Database >Mysql Tutorial >mysql中的Load data的使用方法_MySQL

mysql中的Load data的使用方法_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-01 13:23:391122browse

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
Statement：
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
Previous article：查看修改mysql编码方式让它支持中文(gbk或者utf8)_MySQLNext article：CentOS Linux更改MySQL数据库目录位置具体操作_MySQL

Related articles

See more