摘要:
SELECT a.id,b.name FROM tab1 AS a LEFT JOIN tab2 AS b ON(a.id = p.id) WHERE a.id > 10以上sql返回的结果中name列也许会出现 null 的情况,那么在name字段上使用什么函数可以将出现的 null 改为一个默认... 阅读全文
摘要:
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` ... 阅读全文