, 表示并列的意思(既…又). 比如你create table的时候字段间就是使用,隔开(update也是,别写成and哈).

另一种是 trx id 10078 lock_mode X locks rec but not gap

X: An exclusive (X) lock permits the transaction that holds the lock to update or delete a row.
GAP: A gap lock is a lock on a gap between index records, or a lock on the gap before the first or after the last index record

官网有介绍的: https://dev.mysql.com/doc/refman/8.4/en/innodb-locking.html