I have multithread process which it insert data into a table.
and it return the primary key of the specific row.
how can I promise that my process will return me the exact id which it insert
and not another id of differnt thread?

in oracle it will be fix by sequance
do i sequance in mysql?

An Oracle sequence translates to a MySQL AUTO_INCREMENT.

-PatP