mysql - 存储过程如何返回值

Question

CREATE PROCEDURE deleteDealer 
(**In dealerCode Varchar(100),In userId VARCHAR(100**))
BEGIN
  `UPDATE tbl_dealer SET status='INACTIVE' where dealerCode=dealerCode';
  `UPDATE tbl_dealer_contact SET status='INACTIVE' where dealerCode=dealerCode';
  'UPDATE tbl_login set status='INACTIVE' where userId=userId';


END;

这是我如何返回 bool 值的程序任何人都可以快速回答我

Answer 1

CREATE PROCEDURE deleteDealer 
(**In dealerCode Varchar(100),
In userId VARCHAR(100**))
BEGIN
  `UPDATE tbl_dealer SET status='INACTIVE' where dealerCode=dealerCode';
  `UPDATE tbl_dealer_contact SET status='INACTIVE' where dealerCode=dealerCode';
  'UPDATE tbl_login set status='INACTIVE' where userId=userId';


SELECT 1;

END;