mysql create procedure script

Question

I am a bit confused with mysql create procedure script. My script looks like as follows:

DELIMITER //
DROP PROCEDURE play;
CREATE PROCEDURE play()
BEGIN
insert into hi (name,id)VALUES ('apple','2010');
END
//

It does not insert into table hi.

You need to explain a little more than that. Is this script not working, or does it not insert when you call the PROCEDURE, do you get an error? — Adriaan Stander
– Adriaan Stander, Commented Apr 9, 2010 at 3:18
I figure out how to insert now. I do not use "create procedure". It can work. Now My problem how to use procedure to do? — chnet
– chnet, Commented Apr 9, 2010 at 3:20
It seems that you are under the impression that the above script (by itself) would insert values. The above script only creates the procedure, you need to call the procedure afterwards, to execute it. — Adriaan Stander
– Adriaan Stander, Commented Apr 9, 2010 at 3:24

DVK · Accepted Answer · 2010-04-09 03:33:31Z

1

Your script does not actually execute the play procedure via call command

You need to add

call play

command

answered Apr 9, 2010 at 3:33

DVK

130k33 gold badges220 silver badges337 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user1551590 · Accepted Answer · 2012-07-25 13:15:38Z

0

use

CALL play();

and I suggest use

DROP PROCEDURE IF EXISTS play()

instead DROP PROCEDURE play()

answered Jul 25, 2012 at 13:15

user1551590

15 bronze badges

1 Comment

Yaroslav Over a year ago

What does it adds to the previously accepted answer? Why you recommend the IF EXISTS play()? Comments will be useful for others looking for an answer to have a better understanding of your code

Collectives™ on Stack Overflow

mysql create procedure script

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related