Update table in mysql using stored procedure

Question

I have stored procedure in mysql. The procedure is created, but when the procedure is called I get an error:

"Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the option in Preferences -> SQL Editor -> Query Editor and reconnect."

Here is the procedure:

------------------------------------------------
drop procedure if exists update_per_det;

delimiter //

create procedure update_per_det(IN name varchar(30))

begin

 DECLARE age1 int;

set age1=(select CalAge(name));

update  per_det set age=age1 where username=name;

end;//

delimiter ;

How can I solve this issue?

please learn how to format quotes, code, etc. Read the FAQ for more information. — JonH
– JonH, Commented Mar 30, 2012 at 13:37

rs. · Accepted Answer · 2012-03-30 13:37:20Z

2

Try this:

set age1=(select CalAge(name));

SET SQL_SAFE_UPDATES=0;

update  per_det set age=age1 where username=name;

answered Mar 30, 2012 at 13:37

rs.

27.6k13 gold badges71 silver badges93 bronze badges

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

Comments

Max · Accepted Answer · 2020-06-14 22:00:32Z

0

Use DELIMITER like this:

DROP PROCEDURE IF EXISTS DealStateChange;

DELIMITER //

CREATE PROCEDURE DealStateChange(statusID tinyint)



     UPDATE deals
          SET `status` = statusID
      WHERE `id` = 1001;




//
DELIMITER ;


/* for execute PROCEDURE */
CALL DealStateChange(11);

answered Jun 14, 2020 at 22:00

Max

991 silver badge4 bronze badges

Collectives™ on Stack Overflow

Update table in mysql using stored procedure

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related