使用ID AUTO_INCREMENT创建INSERT并获取该ID以更新另一个表

Question

I need to create a football team in the table equipo where I will insert ID auto_increment, nombre, descripcion.

I need to obtain that ID so that the players are inserted in the table jugadores from another query (or not necessarily). And I need everything done almost at the same time.

Any solution?

I know that lastInsertId gets me the last ID of the last updated table, whatever it is, so it is very possible not to get the ID I need if there is a massive upload of records.

I hope the output is

ID      |    NOMBRE   |    DESC
-------------------------------
1001    |    myname    |   blabla

ID   |  ID_EQUIPO  |   NOMBRE
-------------------------------
1    |  1001       |   Jugador

Answer 1

My solution has finally been this:

    $conexion = new Conexion();
    $consulta = $conexion->prepare('INSERT INTO '.self::TABLA.' (nombre_equipo) VALUES (:nombre_equipo)');     
    $consulta->bindParam(':nombre_equipo',  $this->nombre_equipo);        
    $consulta->execute();
    $this->id= $conexion->lastInsertId(); 

Then I use the ID to insert players