论坛 › CodeIgniter 问答求助 › 请教一个数据库的model

for 发表于 2016-11-22 12:29:42

请教一个数据库的model

如下面的 sql 语句

select realname as name, tel as tel, (select daname from `allset` where `to` = a.key and allset.del=0 order by allset.id desc limit 0,1) as dnam,(select times from `allset ` where `to` = a. key and allset.del=0 order by allset.id desc limit 0,1) as time from student a where key = '1234'


得到

nameteldnam time

请问如果用查询构造器的类来写，该怎么写呢？

Hex 发表于 2016-11-22 13:58:16

复杂 SQL 不建议用 QueryBuilder 来写，另外 QueryBuilder 也不是万能的。

查看完整版本: 请教一个数据库的model