Home > database >  Mysql stored procedures delimiter
Mysql stored procedures delimiter

Time:10-05

Don't look at other code, I created two stored procedures, displayed the internal stored procedure call a stored procedure, then don't know if delimiter, finished call statements with a semicolon direction semicolon error, missing the end, what is wrong with this

CodePudding user response:

The default is; Because you changed the terminator for/to///so

CodePudding user response:

Don't know whether you said each semicolons should change//, but if such that as long as you hit the first//at the back of the statement will not perform, at the back of the statement will be an error?

CodePudding user response:

refer to the second floor qq_44080299 response:
don't know whether you said each semicolons should change//, but if such that as long as you hit the first//at the back of the statement will not perform, at the back of the statement will be an error?


Wrong, there's more to create a stored procedure, you didn't notice, you remove the middle two delimiter try, also can't separate you stored procedure alone to perform have a look, if there is something wrong with the script or symbol Angle problem, all visual don't see a problem

CodePudding user response:

refer to the second floor qq_44080299 response:
don't know whether you said each semicolons should change//, but if such that as long as you hit the first//at the back of the statement will not perform, at the back of the statement will be an error?

Change the end//to end the enter//give it a try

CodePudding user response:

Me all sorts of methods are tried, but I have been an error, bosses to create a stored procedure call each other when you have this problem, could you knock a few lines of code, please verify
  • Related