我通过表实例group by (task_id,task_time)中的create_time将rank赋给每一行作为主键。 task_id, create_time, WHEN @prev_task_time <> task_time THEN 1 @prev_task_id := task_id,
@prev_task_time := t
嗨,我写了这个MySQL存储的proc,我一直收到这个语法错误。#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server@start = 1505469600;;;
我将DELIMITER ;;添加到脚本的顶部,因为在设置变量时一直有语法错误