Change from Postgre to MySQL query error
Hi there,
I tried to switch my application from postgres to mysql. The problem is i don't know how to change below sql query to mysql.
UPDATE datavalue as d1 SET value=d2.value,storedby=d2.storedby,lastupdated=d2.lastupdated,comment=d2.comment,followup=d2.followup FROM datavalue AS d2 WHERE d1.periodid=d2.periodid AND d1.sourceid=d2.sourceid AND d1.lastupdated<d2.lastupdated AND d1.dataelementid=1 AND d1.categoryoptioncomboid=2 AND d2.dataelementid=3 AND d2.categoryoptioncomboid=4;
I was wondering if you guys can help me out.
Thank you very much!
Best regards,
Quang
Subject
Views
Written By
Posted
Change from Postgre to MySQL query error
7120
August 30, 2010 10:45AM
3091
August 31, 2010 02:19AM
3351
September 04, 2010 10:06AM
3453
September 06, 2010 01:18AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.