MariaDB [test]> create table t (id INT NOT NULL auto_increment, s varchar(255),primary key(id));

Query OK, 0 rows affected (0.01 sec)

MariaDB [test]> insert into t (s) values ("abc");

Query OK, 1 row affected (0.00 sec)

MariaDB [test]> select last_insert_id();

+------------------+

| last_insert_id() |

+------------------+

|                1 |

+------------------+

1 row in set (0.00 sec)

MariaDB [test]> insert into t (s) values ("bcd") returning *, last_insert_id();

+----+------+------------------+

| id | s    | last_insert_id() |

+----+------+------------------+

|  2 | bcd  |                1 |

+----+------+------------------+

1 row in set (0.01 sec)

MariaDB [test]> select last_insert_id();

+------------------+

| last_insert_id() |

+------------------+

|                2 |

+------------------+

1 row in set (0.00 sec)

MariaDB [test]>