Mysql 未知标点符号字符串@12错误

Question

我无法理解这段代码有什么问题。请帮忙:

    DELIMITER //
    CREATE TRIGGER `project`.`insert_project_log` AFTER INSERT ON `project`.`projects`
     FOR EACH ROW insert into 
     project_log(user,title,uploaded_file_name,submitted_at,submitted_by) 
     values(new.user,new.title,new.report_file_name,now(),new.submitted_by)
    //
    DELIMITER ;

我得到:

        ERROR: Unknown Punctuation String @ 12
        STR: //
        SQL: 
        DELIMITER //
        CREATE TRIGGER `project`.`insert_project_log` AFTER INSERT ON `project`.`projects`
         FOR EACH ROW insert into 
        project_log(user,title,uploaded_file_name,submitted_at,submitted_by) 
       values(new.user,new.thesis,new.report_file_name,now(),new.submitted_by)
        //

Answer 1

用一个单词或一个字符串命名您的触发器，并封装在反引号中

DELIMITER //

CREATE TRIGGER insert_project_log AFTER INSERT ON `project`.`projects`
FOR EACH ROW 
BEGIN
   insert into project_log(user,title,uploaded_file_name,submitted_at,submitted_by) 
   values(new.user,new.title,new.report_file_name,now(),new.submitted_by);
END
//

DELIMITER ;