I wish to insert a row into a table, in which there is an 'id' field of type integer which is auto-generated/auto-incremented.
Along with the id field, there are some other integer/ varchar fields that have to be inserted.
After the insert, I also wish to obtain the ID assigned to the row that was just inserted into database.
I read through the docs but in the relevant section it says that the format of query can differ from case-to-case in such inserts (where a field is an auto-incrementing integer).
Hence I wish to know if and what is the standard syntax for making such an insert using Spring JDBC?