Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE, 1175 tried

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE, 1175 tried

1 error description

19: 15: 34 call sp_store_insert (90) 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 and reconnect.0.093 sec

2 error cause

Create definer = 'root' @ 'localhost' PROCEDURE 'SP _ store_insert '(in score int) BEGIN create temporary table if not exists temp_student (id int (6) primary key, name varchar (20); delete from temp_student; insert into temp_student (id, name) select t. id, t. name from t_computer_stu t where t. score> score; END

Call sp_store_insert (90 );

3 Solution