Question

mysql创建触发器之前检查是否存在不存在再创建，存在就不创建的sql语句是什么

CREATE
TRIGGER aaa IF NOT EXISTS AFTER INSERT ON ppp
FOR EACH ROW BEGIN
INSERT INTO bbb (tableName,idColumn,dataRecordId,recordType,recordTime) VALUES ("ppp","aa",NEW.aa,1,NOW());
END;
这么写有错啊

Answer 1

-- 判断要创建的存储过程名是否存在
if exists (select * from dbo.sysobjects where id =object_id(N'[dbo].[存储过程名]') and OBJECTPROPERTY(id, N'IsProcedure')= 1)
-- 删除存储过程
drop procedure [dbo].[存储过程名]
GO