Re: [NF] Getting MySQL integer primary keys (NOT AUTOINC) idea...similar to VFP's old IF SEEK("TheTable","Keys","TheTable") AND RLOCK('Keys') idea

On 2016-03-10 11:32, Stephen Russell wrote:

I think there is confusion here. @@Identity returns the tables identity setting I thought, and in SQL Server it gives you your insert's PKey value.

I don't do mySQL but still think that @@Identity gives you how your table is set for PKey incrementation. It could be int or guid.

That's been working since 2004 in my framework! I'm guessing it's reading the table's AutoInc value perhaps and returning that.