mysql - Mysql从表中获取2个ID

Question

我有一个这样的 MySQL 表：

+-----+----------+------------+--------------+-------------+
| id  |  user_id |  added_on  | status_enter | status_exit |
+-----+----------+------------+--------------+-------------+

SQL小提琴

sql代码

select
    tc.id,
    tc.user_id,
    tc.added_on,
    ( select min( tc2.added_on )
      from visitors tc2
      where tc.User_id = tc2.User_id
        and tc.id < tc2.id
        and tc2.status_enter = 0
        and tc2.status_exit = 1 ) EndTime
from
    visitors tc
where
        tc.status_enter = 1

是否可以获得第二个ID（结束时间）？

我需要第二个 ID 来编辑结束时间。

预期产出

+---------+---------+--------+------------+-----------+
| user_id | enter d | exit d | edit enter | edit exit |
+---------+---------+--------+------------+-----------+

    <a href="<?php echo url_for('/admin/visitors/edit.php?id=' . $visitor->id; ?>">Edit enter date</a>

    <a href="<?php echo url_for('/admin/visitors/edit.php?id=' . $visitor->end_time_id???; ?>">Edit exit date</a>

标签： mysql