What is the correct syntax to create a procedure in MySQL to insert data?

Question

I'm trying to write a stored procedure to insert data into a table.

The procedure which I wrote is:

CREATE PROCEDURE insrtem (IN x int(3),IN y varchar(3))

BEGIN

    insert into emp (empid,empname) values (x,y);
END;

but it doesn't work.

What's the correct syntax?

You should specify what the error is.

Gordon Linoff
– Gordon Linoff

2015-03-07 02:53:51 +00:00
Commented Mar 7, 2015 at 2:53 — Gordon Linoff
– Gordon Linoff, Commented Mar 7, 2015 at 2:53

Gordon Linoff · Accepted Answer · 2015-03-07 02:52:27Z

2

In MySQL, you often need a delimiter statement, so that is my first guess:

DELIMITER $$
CREATE PROCEDURE insrtem (IN in_x signed, IN in_y varchar(3))
BEGIN
    insert into emp (empid, empname)
        values (in_x, in_y);
END;
DELIMITER ;

Notice I changed the names of the parameters to have an in prefix. This helps distinguish the parameters from columns in the table.

edited Mar 7, 2015 at 2:52

answered Mar 7, 2015 at 2:43

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

What is the correct syntax to create a procedure in MySQL to insert data?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related