日期: 2016 年 3 月 31 日

在MySQL新增trigger時，出現如下錯誤訊息

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right

試了很久，發現CREATE TRIGGER指令的內容，不可以含Tab值，刪除後就好了。

DROP TRIGGER IF EXISTS FTStrategyInsert;

delimiter |

CREATE TRIGGER FTStrategyInsert AFTER INSERT ON FTStrategy
FOR EACH ROW
BEGIN
INSERT INTO FTStrategyLog
SET StryId = New.StryId,
StryName = New.StryName,
MktRiskAuth = New.MktRiskAuth,
TRoleId = New.TRoleId,
TAcctId = New.TAcctId,
StartDate = New.StartDate,
EndDate = New.EndDate,
Content = New.Content,
ModifyTime = New.ModifyTime,
ModifyEmp = New.ModifyEmp,
ModifyType = 'Insert';
END;
|

delimiter ;

select * from information_schema.triggers where trigger_name='FTStrategyInsert';