常用MYSQL语句随记

作者:笨小孩 发布于:2013-1-31 14:58 分类:数据库

1、多表查询结果导出到本地文本文件。

SELECT ad.aid,arc.title,ad.company  INTO OUTFILE 'd:/company.txt' LINES TERMINATED BY '\r\n' FROM dede_addon17 AS ad LEFT JOIN dede_archives AS arc ON ad.aid=arc.id WHERE ad.cname='';

 

标签: MySQL

发表评论:

手机版 | 
Copyright © 2012 lamp46.com All Right Reserved. sitemap