Re: Change from Postgre to MySQL query error

[Quang Nguyen]

Thank you Devart, it makes sense to me.

Btw, I have another problem, the original postgres query is below:

UPDATE datavalue AS d1 SET dataelementid=1259, categoryoptioncomboid=1 WHERE dataelementid=1261 and categoryoptioncomboid=1 AND NOT EXISTS ( SELECT * FROM datavalue AS d2 WHERE d2.dataelementid=1259 AND d2.categoryoptioncomboid=1 AND d1.periodid=d2.periodid AND d1.sourceid=d2.sourceid );

Then I changed to this:

UPDATE datavalue AS d1 SET dataelementid=1259, categoryoptioncomboid=1 WHERE dataelementid=1261 and categoryoptioncomboid=1 AND NOT EXISTS ( SELECT * FROM (SELECT * FROM datavalue) AS d2 WHERE d2.dataelementid=1259 AND d2.categoryoptioncomboid=1 AND d1.periodid=d2.periodid AND d1.sourceid=d2.sourceid );

But seems it work forever.

It's great to get you help again! Thank you!
Quang