From Xojo Documentation

You are currently browsing the old Xojo documentation site. Please visit the new Xojo documentation site!

MySQLCommunityServer.LastInsertedRowID() As UInt64

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.