Using Like? xxx1,xxx2 are just simbols.For example xxx1 is "Zhang San",xxx2 is "Li Si".
select * from tablename where id='xxx1' or id='xxx2' or ...or id='xxx3000' 一共3000个or id='xxx', 会超过限制吗? 这样的语句也写的出?佩服!!!select * from tablename where id in (select id from .. where ..)
是在不行也要这样 select * from tablename where id in (id1,id2....) 总比or 好多了吧,起码省地方:)
你还是别想最长查询语句这个问题了,还是改进自己的查询语句更重要,要不你现在的语句就是可以执行也和死机差不多。
xxx1,xxx2 are just simbols.For example xxx1 is "Zhang San",xxx2 is "Li Si".
一共3000个or id='xxx', 会超过限制吗?
这样的语句也写的出?佩服!!!select * from tablename where id in (select id from .. where ..)
总比or 好多了吧,起码省地方:)