摘要:
个人认为学习最好的办法就是实践之后总结,很长时间都在用框架,原生的sql语句几乎写不出来,这样不好。。。。。。select count(tid) as 帖子总数,FROM_UNIXTIME(t.postdate),f.name from pw_threads t,pw_forums f where t.fid=f.fid group by t.fidSELECT f.name as fname,ff.name as ffname from `pw_forums` f,`pw_forums` ff where f.fid=ff.fup;单表自连接select count(tid) as tota 阅读全文