mysql 1.取出数据为null,替换为默认值 2.从选出的数据中再筛选数据
SELECT count(*) FROM
(
SELECT
user.*,invite.username as inviteUser,IFNULL(invite.tele ,"")as inviteTele,IFNULL(invite.insert_time ,"")as inviteTime
FROM
user left join (select invite...
原创
2018-08-10 20:51:10 ·
1108 阅读 ·
0 评论