MySQL Forums
Forum List  »  PostgreSQL

Change from Postgre to MySQL query error
Posted by: Quang Nguyen
Date: August 30, 2010 10:45AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Change from Postgre to MySQL query error
6628
August 30, 2010 10:45AM


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.