Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on May 21st, 2012  |  syntax: None  |  size: 0.36 KB  |  hits: 13  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. mysql> delimiter //
  2.  
  3. mysql> CREATE PROCEDURE simpleproc (OUT param1 INT)
  4.     -> BEGIN
  5.     ->   SELECT COUNT(*) INTO param1 FROM t;
  6.     -> END//
  7. Query OK, 0 rows affected (0.00 sec)
  8.  
  9. mysql> delimiter ;
  10.  
  11. mysql> CALL simpleproc(@a);
  12. Query OK, 0 rows affected (0.00 sec)
  13.  
  14. mysql> SELECT @a;
  15. +------+
  16. | @a   |
  17. +------+
  18. | 3    |
  19. +------+
  20. 1 row in set (0.00 sec)
create a new version of this paste RAW Paste Data