进入到mysql的控制台,输入:
SELECT * into OUTFILE 'd:/1.xls' from oneyear ORDER BY TPROVIDERID desc LIMIT 0,50;
1.由c盘符转换到d盘符
c:\Users\a>d:
2.本盘符的转换
c:\Users>cd c:/
SELECT * into OUTFILE 'd:/1.xls' from oneyear ORDER BY TPROVIDERID desc LIMIT 0,50;
1.由c盘符转换到d盘符
c:\Users\a>d:
2.本盘符的转换
c:\Users>cd c:/