Breaking News: Grepper is joining You.com. Read the official announcement!

proc

Sparkling Swan answered on April 27, 2021 Popularity 1/10 Helpfulness 1/10

answer proc

proc

Comment

drop procedure if exists get_user;
delimiter #
create procedure get_user
(
in p_user_id int unsigned,
in p_explain tinyint unsigned
)
begin
  if (p_explain) then
    explain select * from users where user_id = p_user_id;
  end if;
  select * from users where user_id = p_user_id;
end#

delimiter ;

call get_user(1,1);

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: proc whatever

Link to this answer
Share Copy Link