/opt/seatable/seatable-server-latest/sql/mysql/upgrade/2.0/dtable.sql中28行运行出错
ALTER TABLE operation_log ADD INDEX IF NOT EXISTS idx_operation_log_dtable_uuid_op_id (dtable_uuid,op_id);
提示:
ERROR 1064 (42000) at line 28: 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 ‘IF NOT EXISTS idx_operation_log_dtable_uuid_op_id (dtable_uuid,op_id)’ at line 1
简单处理可以改为
ALTER TABLE operation_log ADD INDEX idx_operation_log_dtable_uuid_op_id (dtable_uuid,op_id);