mysql——xls表格的导出和导入(重点)
查看cr01表里面的内容:select * from cr01;
首先导出一个xls文件:select sx,mz,bz from cr01 into OUTFILE ‘C:/Users/del/Desktop/a.xls‘
首先删除数据(情况cr01里面的记录):delete from cr01;
导入xls表格里面的内容:load data infile ‘C:/Users/del/Desktop/a.xls‘ into table cr01;
再次查询cr01里面的内容:select * from cr01;
==========================================================================
数据准备:
导出为xls文件:
select sx,mz,bz from cr01 into OUTFILE ‘C:/Users/del/Desktop/a.xls‘
查询xls文件:
删除cr01里面的内容:
delete from cr01;
导入xls里面的内容:
load data infile ‘C:/Users/del/Desktop/a.xls‘ into table cr01;
查询cr01里面的内容:
select * from cr01;
相关推荐
苏康申 2020-11-13
vitasfly 2020-11-12
CoderToy 2020-11-16
emmm00 2020-11-17
王艺强 2020-11-17
ribavnu 2020-11-16
bianruifeng 2020-11-16
wangshuangbao 2020-11-13
vivenwan 2020-11-13
moyekongling 2020-11-13
云中舞步 2020-11-12
要啥自行车一把梭 2020-11-12
aydh 2020-11-12
kuwoyinlehe 2020-11-12
minerk 2020-11-12
jazywoo在路上 2020-11-11
敏敏张 2020-11-11
世樹 2020-11-11