php - mysql更新倍数为什么不起作用？哦还有 php

Question

我不明白为什么这行不通，每一行都行，但当我将它们连接在一起时却行不通......

mysql_query("
 UPDATE imageProperties
  SET value='98' WHERE element='img1' AND property='left';
  SET value='67' WHERE element='img1' AND property='top';
  SET value='15' WHERE element='img1' AND property='width';
  SET value='15' WHERE element='img1' AND property='height';
  SET value='22' WHERE element='img2' AND property='left';
  SET value='49' WHERE element='img2' AND property='top';
  SET value='62' WHERE element='img2' AND property='width';
  SET value='75' WHERE element='img2' AND property='height';
");

我从这个问题的答案中得到了想法 here

Answer 1

语法错误。您应该为每个集合更新 imageProperties:

UPDATE imageProperties
  SET value='98' WHERE element='img1' AND property='left';
UPDATE imageProperties
  SET value='67' WHERE element='img1' AND property='top';
UPDATE imageProperties
  SET value='15' WHERE element='img1' AND property='width';