how to get IDs after inserted to database

Hello,
in a store procedure I am using multiple inserts:
INSET into tableA (column1,column2)
SELECT a,b FROM ko

tableA(A_ID, column1,column2) where id is the auto number key of the table.

How can I retrieve the IDs that was inserted on tableA, inside the store
procedure?

Do SELECT SCOPE_IDENTITY after the INSERT statement

use this statement SELECT @@IDENTITY after insert statement   

 

if helpful please mark it as answer

@@IDENTITY and SCOPE_Identity() are TSQL (Microsoft SQL) functions which are
probably not implemented yet in MySQL.

Possibly MySQL is limited to a SELECT MAX(ID) immediatly after the Insert to get
the Id of the record just inserted.

If is about MySQL, the you can use SELECT LAST_INSERT_ID()