MySQL Forums
Forum List  »  MySQL Query Browser

Re: Update datetime in MySQL
Posted by: Anjib Mulepati
Date: February 21, 2014 11:50AM

So I get far to this point
update visit
set start_of_service=DATE_ADD(start_of_service, INTERVAL 1 HOUR) ,
end_of_service=DATE_ADD(end_of_service, INTERVAL 1 HOUR)
where (TIME(start_of_service)='23:00:00' OR TIME(end_of_service)='23:00:00') AND
(MONTH(CREATE_DATE) = 1 AND YEAR(CREATE_DATE) = 2014) AND
visit_id IN (
select v.VISIT_ID
from PATIENT_INFORMATION p, VISIT v
where v.PATIENT_INFO_ID = p.PATIENT_INFO_ID and
p.DATA_DOMAIN = 'FOLLOWUP'
);


But I am getting Error code 1093.

I wan to update time in visit table which has matching visit id in patient table.

Options: ReplyQuote


Subject
Written By
Posted
February 20, 2014 05:21PM
Re: Update datetime in MySQL
February 21, 2014 11:50AM


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.