sql - MySQL Procedures -

sql - MySQL Procedures -

would able help me creating procedure reports total amount paid in specific month , specific year? or how go creating this?

thank , help.

i'm guessing have table includes both date column amount paid column. if case, , want sum amount paid can utilize sum() function.

try this:

select sum(totalamountpaid) totalformonth tablename month(datecolumn) = monthyouwant , year(datecolumn) = yearyouwant

here date , time functions may useful.

mysql sql mysql-workbench procedures