This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
The moose likes JDBC and the fly likes MySQL 5.0 and stored procedures.. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "MySQL 5.0 and stored procedures.." Watch "MySQL 5.0 and stored procedures.." New topic
Author

MySQL 5.0 and stored procedures..

Balaji Loganathan
author and deputy
Bartender

Joined: Jul 13, 2001
Posts: 3150
Hi,
Have anyone tried using stored procedure in mysql 5.0?.
I am quite familiar in using stored procedure with MS sql server, but somehow i am always getting "check your syntax error" in mysql 5.0 while trying stored procedure.

If you some good links that you have tried already, please let me know.
Cheers
Balaji


Spritle Software Blogs
Talhah Mafawalla
Greenhorn

Joined: Nov 05, 2006
Posts: 24
Hi Balaji,

You can try searching for stored procedures on the following link:
http://dev.mysql.com/doc/refman/5.0/en/

Or download the MySQL documentation on this link:
http://dev.mysql.com/doc/index.html

Hope this helps
Mathias Nilsson
Ranch Hand

Joined: Aug 21, 2004
Posts: 367
A test




.. Works. Every line must end with ;


SCJP1.4
Balaji Loganathan
author and deputy
Bartender

Joined: Jul 13, 2001
Posts: 3150
Hi Mathias,
Thanks for the test code. Sorry for my late reply.
I still couldn't able to get through with it. I am using windows mysql administrator connected to redhat mysql5.0.

If i have a simple table called "Employee" with two columns Name & Age
Table: Employee
Column1: Name - VARCHAR(255)
Column2: Age - INT

then how would the stored procedure for inserting datas will look like ?
Balaji Loganathan
author and deputy
Bartender

Joined: Jul 13, 2001
Posts: 3150
Finally i got it working, i will soon write here how i did it.
Balaji Loganathan
author and deputy
Bartender

Joined: Jul 13, 2001
Posts: 3150
Originally posted by Balaji Loganathan:
Finally i got it working, i will soon write here how i did it.

Well here is a very well written document.. http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.pdf
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: MySQL 5.0 and stored procedures..