1

One can read everything about the last_insert_id() out there. This makes me think that, in MySQL, there is no way to get other column values after an INSERT statement than the auto increment column of a table.

To be more clear: If I have a table with column A (not necessarily a PK) that is generated by a trigger before insert, could I get the generated value after the INSERT ? Just like last_insert_id() would, just that I want to specify my custom column to return.

Thank you !

Tchypp
  • 1,075
  • 2
  • 13
  • 20

0 Answers0