Q:How can create store procedure ?

·  CREATE PROCEDURE proc1 () : Parameter list is empty

·  CREATE PROCEDURE proc1 (IN varname DATA-TYPE) : One input parameter. The word IN is optional because parameters are IN (input) by default.

·  CREATE PROCEDURE proc1 (OUT varname DATA-TYPE) : One output parameter.

·  CREATE PROCEDURE proc1 (INOUT varname DATA-TYPE) : One parameter which is both input and

Create store procedure

delimiter //

CREATE PROCEDURE simpleproc (OUT param1 INT)

BEGIN

  SELECT COUNT(*) INTO param1 FROM t;

END//

delimiter ;

call store procedure

CALL simpleproc(@a);

Result 

mysql> SELECT @a;

+------+

| @a   |

+------+

| 3    |

+------+

Drop store procedure

DROP PROCEDURE IF EXISTS simpleproc;