MySQL觸發器怎麽變相使用動態SQL

MySQL觸發器動態sql：

CREATE TRIGGER trigger1 after INSERT ON cdr

FOR EACH ROW

BEGIN

DECLARE id BIGINT;

DECLARE vname VARCHAR(200);

DECLARE destination VARCHAR(200) DEFAULT 'null';

DECLARE rows1 BIGINT DEFAULT 0;

DECLARE sql1 VARCHAR(2000);

SELECT v.vendorid,v.name, ve.DestinationID INTO id, vname, destination

FROM (select name, v.VendorID from vendor v natural join vendorendpoints where endpoint=NEW.Field27) v NATURAL JOIN (SELECT * FROM vendorextraction order by length desc) ve