Refer to the documentation for more examples and syntax, at https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html.