UPDATE wap2 AS q,wap1 AS w
SET q.h=w.name,
q.l=w.parent_classes,
q.t=w.classes,
q.p=w.parent
WHERE q.uri=w.address;
UPDATE wap2 AS q,wap1 AS w
SET q.h=w.name,
q.l=w.parent_classes,
q.t=w.classes,
q.p=w.parent
WHERE q.host=w.address AND LENGTH(CONCAT(w.name,w.classes,w.parent,w.parent_classes))=0 AND LENGTH(q.l)=0 ;
UPDATE wap2 AS q,wap1 AS w
SET q.h=w.name,
q.l=w.parent_classes,
q.t=w.classes,
q.p=w.parent
WHERE q.domain=w.address AND LENGTH(CONCAT(w.name,w.classes,w.parent,w.parent_classes))=0 AND LENGTH(CONCAT(q.l,q.t)=0;
SET q.h=w.name,
q.l=w.parent_classes,
q.t=w.classes,
q.p=w.parent
WHERE q.uri=w.address;
UPDATE wap2 AS q,wap1 AS w
SET q.h=w.name,
q.l=w.parent_classes,
q.t=w.classes,
q.p=w.parent
WHERE q.host=w.address AND LENGTH(CONCAT(w.name,w.classes,w.parent,w.parent_classes))=0 AND LENGTH(q.l)=0 ;
UPDATE wap2 AS q,wap1 AS w
SET q.h=w.name,
q.l=w.parent_classes,
q.t=w.classes,
q.p=w.parent
WHERE q.domain=w.address AND LENGTH(CONCAT(w.name,w.classes,w.parent,w.parent_classes))=0 AND LENGTH(CONCAT(q.l,q.t)=0;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货