MySQL Forums
Forum List  »  Stored Procedures

stored procedure truncating
Posted by: stephen coffey
Date: April 20, 2018 10:44AM

This is likely a really simple oversight on my part. I have two stored procedures that look like this:

UPDATE joblisttable
INNER JOIN joblistfromdevice
ON joblisttable.jobnumber=joblistfromdevice.jobnumber
SET joblisttable.jobstart= joblistfromdevice.jobstart;


DELETE joblistfromdevice
FROM joblistfromdevice
INNER JOIN joblisttable ON joblisttable.jobnumber=joblistfromdevice.jobnumber;

Whenever I put them into the same SP, everything after the first ";" is removed on saving. Any ideas?

Thanks in advance!

Options: ReplyQuote


Subject
Views
Written By
Posted
stored procedure truncating
251
April 20, 2018 10:44AM
151
April 20, 2018 11:46AM


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.