The following examples are equal to the examples from the previous page (PHP Insert Data Into MySQL), except that we have added one single line of code to retrieve the ID of the last inserted record.

So, I change to: DECLARE @t TABLE (ID int) INSERT INTO FATest (acol) OUTPUT INSERTED.ID INTO @t VALUES ('a test') SELECT * FROM @t (this query works fine when run in M$ SQL Server Management Studio ...

How to get last inserted date of a certain record using php and How to select last inserted value of specific column among PHP Get ID Of Last Inserted Data In MySQL SourceCodester PHP MySQL - Get ID ...