⟩ Tell us what is a procedure or a stored procedure in database?
Procedures are sort of functions in a database. Procedures are created when you want to perform a task repetitively.
MariaDB procedure is a stored program that is used to pass parameters into it. It does not return a value like a function does.
You can create and drop procedures like functions.