MySQLCommunityServer.LastInsertedRowID
From Xojo Documentation
Method
MySQLCommunityServer.LastInsertedRowID() As UInt64
New in 2019r2
Supported for all project types and targets.
New in 2019r2
Supported for all project types and targets.
Returns as an UInt64 the value of the AUTOINCREMENT field for the last row that was inserted.