aspose file tools
The moose likes JDBC and Relational Databases and the fly likes how to create MySql stored procedure? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of RabbitMQ in Depth this week in the Open Source forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how to create MySql stored procedure?" Watch "how to create MySql stored procedure?" New topic
Author

how to create MySql stored procedure?

harilal ithikkat
Ranch Hand

Joined: Oct 06, 2008
Posts: 221
i tried this way



can anyone fix this issue?


SCJP 1.5
"A candle looses nothing by lighting another candle"
itechmentors.com
ujjwal soni
Ranch Hand

Joined: Mar 28, 2007
Posts: 403
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)


Cheers!!!
Ujjwal B Soni <baroda, gujarat, india> <+918866008962>
"Helping hands are better than praying lips......"
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: how to create MySql stored procedure?