Mysql Begin End statement error

Question

The poster wanted to write a complex statement, but it always reported the error begin end, so he simplified it to just one sentence, but it was still wrong. After querying the statement, I really don’t know where the problem is. The poster’s code is like this of

The error is like this:

I don’t know what the problem is, please answer~~

Answer 1

begin..end.. Do you want to write a transaction or a stored procedure? Begin should be followed by a colon at the beginning of the transaction. If it is a stored procedure, check out the syntax. The syntax for this kind of problem is very clear, or you can find an example. I went to compare and write, but I didn’t even bother to answer when I posted it here. .