how to create MySql stored procedure?

[harilal ithikkat]

i tried this way

 
mysql> use student;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

mysql>  DELIMITER //
mysql> CREATE PROCEDURE GetAllProducts()
    ->    BEGIN
    -> select * from login;
    -> END //
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'PROCEDURE GetAllProducts()
   BEGIN
select * from login;
END' at line 1
mysql>

   

can anyone fix this issue?

[ujjwal soni]

Hi,

Try doing this way.


mysql> delimiter //

mysql> CREATE PROCEDURE simpleproc (OUT param1 INT)
-> BEGIN
-> SELECT COUNT(*) INTO param1 FROM t;
-> END;
-> //
Query OK, 0 rows affected (0.00 sec)

mysql> delimiter ;

mysql> CALL simpleproc(@a);
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT @a;
+------+
| @a |
+------+
| 3 |
+------+
1 row in set (0.00 sec)