If I have a table which has 3 columns (ID, firstname, lastname), where 'ID' is an auto-increment data type is there any way to retrieve the auto-increment value during row creation?
Considering the following statement:
INSERT INTO table (firstname, lastname) VALUES ('Bob', 'Roberts');
Can I find out what the value of 'ID' is when the statement above is executed?
Is there any way to get th