How to assign an inserted id during an INSERT query?

Question

MySQL

if (!isset($_SESSION['uid'])) {
    $this->pdo('insert into users set login = ?', [
        // сюда нужно вставить значение 'Пользователь-айди_под_которым_вставлена_строка'
    ]);
    $_SESSION['uid'] = $this->connection->lastInsertId(); // с этим как раз-таки всё понятно
}

Such is the question, that is, is it possible to do this without first determining the id_under_which_the_line_is_inserted?

Why, if asked: create a temporary account, which will then be filled with a normal login there with a password, soap with confirmation.

Answer 1

Analogues lastInsertId() Get current auto increment value from information_schema or via TABLE STATUS
SELECT LAST_INSERT_ID();

SELECT AUTO_INCREMENT
FROM information_schema.tables
WHERE table_name = 'table_name'
AND table_schema = DATABASE( ) ;

SHOW TABLE STATUS LIKE 'table_name'