中国网络渗透测试联盟

标题: 如何导出Mysql数据库表为xls文件的查询语句 [打印本页]

作者: admin    时间: 2013-2-27 21:42
标题: 如何导出Mysql数据库表为xls文件的查询语句

select uid,username,password,email,lastip,lastvisit into outfile 'd:/50w.xls' from cdb_members where lastip >'' order by uid desc limit 0,500000;
select uid,username,password,email,lastip,lastvisit into outfile 'd:/50w-100w.xls' from cdb_members where lastip >'' order by uid desc limit 500001,1000000;
select uid,username,password,email,lastip,lastvisit into outfile 'd:/all2.xls' from cdb_members where lastip >'' order by uid desc limit 1000001,10;
select uid,username,password,email,lastip,lastvisit into outfile 'd:/all2.xls' from cdb_members where lastip >'' order by uid desc limit 0,500000;
select uid,username,password,email,regip,from_unixtime(regdate) as regdate,lastip, from_unixtime(lastvisit) as lastvisit from cdb_members where username ='admin'
select uid,username,password,email,regip,from_unixtime(regdate) as regdate,lastip, from_unixtime(lastvisit) as lastvisit  into outfile 'd:/admin.xls'  from cdb_members where groupid <5;
select uid,username,password,email,regip,from_unixtime(regdate) as regdate,lastip, from_unixtime(lastvisit) as lastvisit  into outfile 'd:/50w.date.data.xls'  from cdb_members where lastip >'' order by uid desc limit 0,500000;

select uid,username,password,email,regip,from_unixtime(regdate) as regdate,lastip, from_unixtime(lastvisit) as lastvisit  into outfile 'd:/50w.date.data.xls'  from cdb_members  order by uid desc limit 0,500000;




欢迎光临 中国网络渗透测试联盟 (https://cobjon.com/) Powered by Discuz! X3.2