更新时间:2023-12-03 20:27:22
尝试一下:
SELECT ID, `time` AS time1, (SELECT MIN(st.`time`) FROM T1 st WHERE st.ID = T1.ID AND st.`time` > T1.`time`) AS time2 FROM T1
创建新列,并在MySql中向上移动行
在 pandas 中使用动态名称创建新的数据框,并添加新列