例:删除jumpserver历史会话
MariaDB [jumpserver]> desc terminal_session; #查询表结构+------------------+---------------+------+-----+---------+-------+| Field | Type | Null | Key | Default | Extra |+------------------+---------------+------+-----+---------+-------+| id | char(32) | NO | PRI | NULL | || user | varchar(128) | NO | | NULL | || asset | varchar(1024) | NO | | NULL | || system_user | varchar(128) | NO | | NULL | || login_from | varchar(2) | NO | | NULL | || is_finished | tinyint(1) | NO | | NULL | || has_replay | tinyint(1) | NO | | NULL | || has_command | tinyint(1) | NO | | NULL | || date_start | datetime(6) | NO | MUL | NULL | || date_end | datetime(6) | YES | | NULL | || terminal_id | char(32) | YES | MUL | NULL | || remote_addr | varchar(15) | YES | | NULL | || date_last_active | datetime(6) | NO | | NULL | || protocol | varchar(8) | NO | | NULL | || org_id | varchar(36) | NO | MUL | NULL | |+------------------+---------------+------+-----+---------+-------+15 rows in set (0.00 sec)
MariaDB [jumpserver]> select user,asset from terminal_session where date_start like '%2021-04-08%'; #查看指定日期登陆用户+-----------+------------------------------------------+| user | asset |+-----------+------------------------------------------+| xieyiyuan | 医院应用服务器 || xieceshi | 测试应用服务器 || xieyiyuan | 医院应用服务器 || xieyujian | 预检功能医学数据 应用服务器 || xieyujian | 预检功能医学数据 应用服务器 || xieyujian | 预检功能医学数据 应用服务器 || xieyujian | 医院pacs数据和应用 || xieyujian | 预检功能医学数据 应用服务器 || xieyujian | 预检功能医学数据 应用服务器 || xieyiyuan | 医院应用服务器 || xieyiyuan | 医院应用服务器 |+-----------+------------------------------------------+11 rows in set (0.01 sec)MariaDB [jumpserver]> delete from terminal_session where date_start like '%2021-04-08%'; #删除2021-04-08日期的信息Query OK, 11 rows affected (0.04 sec)MariaDB [jumpserver]>
