那些臭名昭著的sql

浏览数：52 / 时间：2015年06月12日
  • 两个或多个表关联，没写where条件，大量的笛卡尔值，严重时会导致数据库有问题。
select * from a, b left join c on b.id = c.id left join d on c.id = d.id
  • 多表关联查询，where条件使用各种函数，导致索引无效。数据量如果打起来以后会导致查询像蜗牛一样。
select 
trim(d.circuitid) as circuitid,
trim(d.Code) as Code,
trim(d.Oldname) as Oldname,
trim(d.Circuittype) as Circuittype,
trim(d.Status) as Status,
trim(d.customerid) as acustomerid,
trim(d.alinkman) as alinkman,
trim(d.zlinkman) as zlinkman,
trim(d.alinkmantel) as alinkmantel,
trim(d.zlinkmantel) as zlinkmantel,
trim(d.busi_no) as busi_no,
trim(d.service_serial) as service_serial,
trim(a.region_ID) as regionid ,
2 as SORTID
from test1 a,test2 b,test3 c,test4 d 
where trim(a.room_id)=trim(b.roomID) and trim(b.neid)=trim(c.neid) and (trim(c.portid)=trim(d.aendname) or trim(c.portid)=trim(d.zendname))

 

郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。

标签： class style log 使用 si it 问题 数据 la class style log 使用 si it 问题 数据 la

相关文章

随机文章

您可能还喜欢

您可能还喜欢