update 为什么不修改数据了？急啊大家看看
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;
[解决办法]
看看是不是已经没有要修改的数据了，你光贴这些没有用的
