将txt文件导入mysql数据库_MySQL
来源:动视网
责编:小采
时间:2020-11-09 19:26:24
将txt文件导入mysql数据库_MySQL
将txt文件导入mysql数据库_MySQL: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
导读将txt文件导入mysql数据库_MySQL: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

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'
将txt文件导入mysql数据库_MySQL
将txt文件导入mysql数据库_MySQL: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