SELECT bf.message, bf.target_ids, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.uid='1' ORDER BY b.dateline DESC LIMIT 0,10 请大侠解释下什么意思 我不太明白
晕,就一个左连接问题啊! uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid//这有段是左连接,意思选择所有uchome表的数据,当bf.blogid=b.blogid时,将uchome_blogfield的数据连接到左边。SELECT bf.message, bf.target_ids, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.uid='1' ORDER BY b.dateline DESC LIMIT 0,10 整条语句的意思就是查找b.uid='1'的左连接结果相关信息!
uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid//这有段是左连接,意思选择所有uchome表的数据,当bf.blogid=b.blogid时,将uchome_blogfield的数据连接到左边。SELECT bf.message, bf.target_ids, b.* FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.uid='1' ORDER BY b.dateline DESC LIMIT 0,10
整条语句的意思就是查找b.uid='1'的左连接结果相关信息!