Get Auto-Generated ID Created By INSERT SQL
If you have a database table with an auto-generated numerical index field, you may need to retrieve the value of this field after an INSERT statement. In Microsoft Access such a field uses an “AutoNumber” data type. In MySQL it’s known as an “auto_increment” field. We often see these types of fields where a relationship […]