Go to Topic: Previous•Next
Go to: Forum List•Message List•New Topic•Search•Log In•Print View
how can execute procedure
Posted by: Ravisankar (115.249.38.---)
Date: May 25, 2011 05:30AM

i need help for procedure. begin .... end is not work. Please give the sample procedure program

Options: Reply•Quote
Re: how can execute procedure
Posted by: grantsdigital (---.pppoe-dynamic.High-Speed.ns.bellaliant.net)
Date: May 25, 2011 09:05AM

Can you provide better clarification on what you are trying to do?

William Grant
Founder of Grant's Digital
[www.grantsdigital.com]

Options: Reply•Quote
Re: how can execute procedure
Posted by: Ravisankar (115.249.38.---)
Date: May 26, 2011 05:29AM

i am try

CREATE PROCEDURE bran(IN bna varchar)
BEGIN
insert into branch(bname) values(bna)
END

get the following error

#1064 - 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 ') BEGIN insert into branch(bname) values(bna) END' at line 1

Options: Reply•Quote
Re: how can execute procedure
Posted by: stevenmartin99 (---.251.255.12.threembb.ie)
Date: May 26, 2011 06:15AM

Look at the mysql manual .

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Options: Reply•Quote
Re: how can execute procedure
Posted by: grantsdigital (---.pppoe-dynamic.High-Speed.ns.bellaliant.net)
Date: May 26, 2011 07:35AM

I would use dbForge Studio for MySQL and download the express version [www.devart.com] . It a free database management software and you can creating procedure graphically. Though you still need to write some code. There allot of other great features too which you will find out by viewing their website.


I found dbForge Studio made my database life management life allot easier. Good luck.

William Grant
Founder of Grant's Digital
[www.grantsdigital.com]

Options: Reply•Quote
Re: how can execute procedure
Posted by: Ravisankar (115.249.38.---)
Date: May 26, 2011 09:44AM

My problem is solved for using dbForge Studio.

Thank you for all and special thanks to William Grant.

Options: Reply•Quote


Go to: Forum List•Message List•Search•Log In
Sorry, only registered users may post in this forum.
Click here to login