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-09 19:55, Stephen Russell wrote:

why not this?

INSERT INTO table_name (col1, col2,...) VALUES ('val1', 'val2'...);SELECT LAST_INSERT_ID();

Sometimes you have to use the tool as intended.

Well that's basically what I'm doing, but it's in a framework so re-use is key. You don't put this after each task-specific SQL; that's why I had that subroutine. (Am I showing my age there? Does anybody say 'subroutine' anymore??? Reminds me of learning FORTRAN in the LATE 80s at Penn State!)