MySQL错误:1064 while calling a stored procedure from an event

Question

CREATE EVENT E_UpdateTimestampFields
ON SCHEDULE
EVERY 1 MINUTE
STARTS TIMESTAMP(CURRENT_DATE,'00:00:00')
ON COMPLETION PRESERVE
DO `ndwnaleveringen`
CALL spc_UpdateTimeStampFields();

这是用于创建事件的代码，该事件将调用存储过程 spc_UpdateTimeStampFields()。 ndwnaleveringen 是数据库的名称。执行此事件时出现错误

Error Code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL >server version for the right syntax to use near 'CALL spc_UpdateTimeStampFields()' at line 7

Answer 1

尝试

CREATE EVENT E_UpdateTimestampFields
ON SCHEDULE
EVERY 1 MINUTE
STARTS TIMESTAMP(CURRENT_DATE,'00:00:00')
ON COMPLETION PRESERVE
DO 
  CALL ndwnaleveringen.spc_UpdateTimeStampFields();