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 Wed, Mar 9, 2016 at 6:17 PM, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:

...I did NOT want to use auto-increment keys in the tables because I wanted to have more control over them during data-entry, so basically, I can create all kinds of records and then at save time AND ONLY THEN do I want to store the actual data (and that's why AUTOINC keys wouldn't work).

Fun Fact: If you were to create 1000 PKs a day and throw them away, and you worked 365 days/year, you would run out of 4-byte integers in 11,767 years.

Of course, if you were to create GUIDs, the universe would likely end first.