用户登录
设为主页|
淘宝铺|
加入收藏|
您的IP：3.144.96.108您的操作系统：Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
您的IP：3.144.96.108您的操作系统：Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
个人便签
知识库
mysql后台数据通过sql语句导入到文件中
导入到文本文件
例如：
SELECT u.uid,u.email,u.username,us.regip,us.lastip, us.lastvisit , us.lastactivity, us.lastpost from pre_common_member u left join pre_common_member_status us on u.uid=us.uid into outfile './club.sql';
SELECT * FROM `pre_common_member_action_log` into outfile './club.sql';
导入到csv文件
SELECT id,title,type INTO OUTFILE 'e:\\output_01.csv'
FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM music;