select a.*(列),b.name(列) clientName(列),c.url img (列)
from info_change(表) a
left join client(表) b on a.client_id = b.id(条件)
left join s_image(表) c on a.id = c.text_id(条件)
where 1=1 (查询条件)
多表查询(左连接)
------------------------------------------------------
select a.*(列),b.name(列) clientName(列),c.url img (列)
from info_change(表) a
right join client(表) b on a.client_id = b.id(条件)
right join s_image(表) c on a.id = c.text_id(条件)
where 1=1 (查询条件)
多表查询(右连接)
------------------------------------------------------
select a.*(列),b.name(列) clientName(列),c.url img (列)
from info_change(表) a
inner join client(表) b on a.client_id = b.id(条件)
inner join s_image(表) c on a.id = c.text_id(条件)
where 1=1 (查询条件)
多表查询(内连接)
------------------------------------------------------
select a.*(列),b.name(列) clientName(列),c.url img (列)
from info_change(表) a
full join client(表) b on a.client_id = b.id(条件)
full join s_image(表) c on a.id = c.text_id(条件)
where 1=1 (查询条件)
多表查询(全连接)
------------------------------------------------------
update information(表名) set status = ? , server_phone = ?, server_name = ?,server_company =?,address=?,width=?,height=?,face=?,light=?,business=?,dangqi=? where number = ? (条件)
?为属性值dao用get获取
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载