摘要: $gift_category->join('AS b /*INNER JOIN*/'); 阅读全文
posted @ 2014-05-26 14:32 笨马儿 阅读(313) 评论(0) 推荐(0) 编辑
摘要: select `id`,`name`,`pid` AS `q_pid`,(select id From qiyu_gift_category where id = q_pid ) as root_id from qiyu_gift_category WHERE id = 1SELECT `id` ... 阅读全文
posted @ 2014-05-26 14:30 笨马儿 阅读(850) 评论(0) 推荐(0) 编辑