Home >Database >Mysql Tutorial >mysql中的Load data用法_MySQL
mysql中的Load data用法_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:36:501183browse
bitsCN.com
测试把txt文件导入至mysql数据库中：
table：
View Code CREATE TABLE `pet` (`name` varchar(20) DEFAULT NULL,`owner` varchar(20) DEFAULT NULL,`species` varchar(20) DEFAULT NULL,`sex` char(1) DEFAULT NULL,`birth` date DEFAULT NULL,`death` date DEFAULT NULL)
txt文件：D:/data.txt （txt文件下载）
txt中使用 '/N' 描述null值。
导入数据：
View Code load data local infile 'D:/data.txt' into table petlines 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 count distinct null使用注意事项_MySQLNext article：用mysqldumpslow分析执行较慢的SQL语句_MySQL