Few Basic point about write procedure

DELIMITER $$

DROP PROCEDURE IF EXISTS `DataBaseName`.`ProcedureName`$$

CREATE  PROCEDURE `ProcedureName`(
    IN _companyid INT,
    OUT _retVal INT)
BEGIN
            DECLARE EXIT HANDLER FOR SQLEXCEPTION ROLLBACK;
            DECLARE EXIT HANDLER FOR SQLWARNING ROLLBACK;
   
                              START TRANSACTION;
                                       SET _retVal =0 ;
   
                                         UPDATE TableName SET ColunmnName=Value WHERE Condition;   
                                         COMMIT;
                                      SET _retVal =1 ;
    END$$

DELIMITER ;


Delimiter is used for as procedure initating point and ending point on query editor.
DROP is used for remove procedure from stored procedure if it already there.
Create Procedure is used for to create a new Procedure with given condition.
IN is used for taking argument.
OUT is used for returning  value from procedure after execution.



and for execution :

Call ProcedureName (5);
=>Call is used for to execute that procedure and passing that argument inside procedure.

 

 NOW()  function is used for current time to insert.


select MAX(columnName) from TableName;