您尝试为列设置值的方式是更新.因为你是在插入操作完成之后做的.

The way you are trying to set value to a column is an update. Because you are doing it after insert operation is completed.

您实际上需要一个 before 触发器.

You actually need a before trigger.

并且要为同一个表的主键列分配相同的新自增值，***从information_schema.tables中获取.

And to assign the same new auto incremented value of primary key column of same table, you better get it from information_schema.tables.

示例:

delimiter //
drop trigger if exists bi_table_name //

create trigger bi_table_name before insert on table_name
for each row begin
  set @auto_id := ( SELECT AUTO_INCREMENT 
                    FROM INFORMATION_SCHEMA.TABLES
                    WHERE TABLE_NAME='table_name'
                      AND TABLE_SCHEMA=DATABASE() ); 
  set new.priority= @auto_id;
end;
//

delimiter ;

注意:确保您没有任何具有相同名称和/或操作的预定义触发器.如果有，则在创建新的之前删除它们.

Note: Make sure that you don't have any pre-defined trigger with the same name and/or action. If have some, then drop them before creating the new.

观察:
根据 关于 的 mysql 文档last_insert_id(),

"如果您使用单个 INSERT 语句插入多行，LAST_INSERT_ID() 返回为第一个插入生成的值仅行."

"if you insert multiple rows using a single INSERT statement, LAST_INSERT_ID() returns the value generated for the first inserted row only."

因此，批量插入中依赖于 last_insert_id() 和 auto_increment 字段值似乎不可靠.

hence, depending on last_insert_id() and auto_increment field values in batch inserts seems not reliable.