What is the Procedure

Question

hello people 🌼
what is the procedure
, is the definition of the procedure's parameters is done directly from the form input or from an existing table in the database

p.s sorry if there is any mistakes, English is not my native language ^___^

Answer 1

there are many object in database, not just table. one of them is procedure. with procedure you can save many operations or command into simple one.

you don't have to define parameter for each prpcedure, it depends on what kind of procedure you create.

example you want to SELECT 5 table using JOIN, your script will look like a mesh if you just put in in your program. you can transform it to procedure so maybe you just need to write
CALL showJoin ()

it's an example for Procedure with no param

Answer 2

example for other procedure for showing sum of all transaction base on date and stuff id.
CALL showDaySum(date, stuff_id)

parameter is define when you build your procedure. so it's not user.

procedure is like function, but function needs return a value. procedure more flexible than that.