Home >Database >Mysql Tutorial >将txt 文件导入mysql数据库_MySQL
将txt 文件导入mysql数据库_MySQL
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-01 13:10:131306browse
txt文件导入到mysql中命令：
在mysql数据库控制台输入：
use trends_trading_ssytem
load data local infile 'D://data.txt' into table t_stock fields terminated by '/t';
fields terminated by','
lines terminated by'/r/n'
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：Ubuntu12.04中编译Mysql5.6.17_MySQLNext article：Mysql的表分区_MySQL