从触发器或mysql中的存储过程调用REST API? [英] Calling a REST API from a trigger or stored procedure in mysql?

问题描述

我想从存储过程中以 POST 方法调用rest api或在Windows上的mysql服务器中触发.

I want to call rest api in a POST method from a stored procedure or trigger in mysql server on windows.

如何仅通过MySQL执行此操作?

How do I perform this solely with MySQL?

推荐答案

您可以使用mysql-udf-http，然后创建如下触发器:

You can use a mysql-udf-http and then create a trigger like this:

delimiter $$
CREATE TRIGGER upd_check BEFORE UPDATE ON account 
FOR EACH ROW 
  BEGIN 
    IF NEW.amount > 0 THEN 
      set @json = select json_object(account_id,amount) 
      select http_post('http://restservice.example.com/account/post',@json); 
    END IF; 
  END;$$ 

delimiter;

这篇关于从触发器或mysql中的存储过程调用REST API?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！