【数据库适配】瀚高、金仓、达梦、MySQL

【数据库适配】瀚高、金仓、达梦、MySQL

MySQL

新增

修改

删除

查询

触发器

-- Drop the function if it exists
DROP FUNCTION IF EXISTS demofunction();

-- Create or replace the function
CREATE OR REPLACE FUNCTION demofunction() RETURNS INT
LANGUAGE plpgsql
AS $function$
DECLARE
    -- Function-local variables
    v_app_id INT;
    v_app_name VARCHAR(20) := '测试';
BEGIN
    SELECT app_id INTO v_app_id FROM uac_application WHERE app_name = v_app_name;
    RETURN v_app_id;
END;
$function$;

-- Call the function and select the result
SELECT demofunction();

存储过程

-- Drop the procedure if it exists
DROP PROCEDURE IF EXISTS demoprocedure;

-- Create or replace the stored procedure
CREATE OR REPLACE PROCEDURE demoprocedure()
AS $procedure$
DECLARE
    v_app_id INT;
    v_app_name VARCHAR(20) := '测试';
BEGIN
    -- Your logic to retrieve app_id
    SELECT app_id INTO v_app_id FROM uac_application WHERE app_name = v_app_name;

    -- You can add additional logic here if needed
    
    -- This line is optional and can be omitted if you don't want to return anything
    -- RETURN NULL;
END;
$procedure$ LANGUAGE plpgsql;

-- Call the procedure and select the result
CALL demoprocedure();

达梦

瀚高

金仓