StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
15053944
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2013-02-24T16:40:31.163
FavoriteCount
0
LastActivityDate
2017-03-28T07:24:57.250
LastEditDate
2017-03-28T07:24:57.250
LastEditorUserId
1291428
OwnerUserId
1291428
ParentId
15053842
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
In Mysql (which differs from Oracle), <code>DECLARE</code> goes after <code>BEGIN</code> Your code should be: <pre><code>DELIMITER $$ DROP PROCEDURE IF EXISTS EditEnterprise$$ CREATE PROCEDURE EditEnterprise( IN pEnterpriseId VARCHAR(32), IN pEnterpriseName VARCHAR(64) ) BEGIN /* declare the new variables */ DECLARE nEnterpriseId VARCHAR(32); DECLARE nEnterpriseName VARCHAR(64); /* declare the old variables */ DECLARE oEnterpriseId VARCHAR(32); DECLARE oEnterpriseName VARCHAR(64); SET autocommit = 0; /* get the old variables */ SELECT Enterprise_ID := oEnterpriseId, Enterprise_Name := oEnterpriseName FROM enterprise WHERE Enterprise_ID = pEnterpriseId; /* set the variables with the new inputs */ IF pEnterpriseName IS NULL THEN SET nEnterpriseName = oEnterpriseName; ELSEIF pEnterpriseName = '' THEN SET oEnterpriseName = NULL; ELSE SET nEnterpriseName = pEnterpriseName; END IF; UPDATE enterprise SET Enterprise_Name = nEnterpriseName WHERE Enterprise_ID = pEnterpriseId; COMMIT; END$$ DELIMITER ; </code></pre> I also added the missing <code>;</code>, <code>THEN</code> and <code>END IF</code> keywords. Also, take note that you might have a typo at this line: <pre><code>SET oEnterpriseName = NULL; </code></pre> You probably meant: <pre><code>SET nEnterpriseName = NULL; </code></pre> <hr> Now I think you should reconsider your stored procedure. Indeed, all this could be done in a single SQL query. Do you really need a stored procedure for this? Except if you have a restrictive grants policy it might just be superfluous.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POHaving issues with MySQL Stored Procedure with multiple statements
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USSebas
UserOwnerUserId
1. USSebas
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COThanks Sebas, thanks for this great input, I will be posting a short answer which I kinda figure it out myself. Regarding to its functional validity, this is a simple update query and my initial aiam is to create a table with modular CRUD for future use. I think stored procedure is something which helps to modularize my codes. I am new to SP in mySQL and was working on MSSQL previously!
 singulars
 PostPostId
 PO
 UserUserId
 USswfong

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.