MySQL does not have a way to return the result of an insert. It returns only the number of inserted records.
If you rely on auto generated primary keys (AUTO_INCREMENT in MySQL terms, which is the default for most people), there is a way to get it back wit a call to the LAST_INSERT_ID() function; You could then load the record back. However that would work only for an insert of a single record. For bulk inserts, that function returns only the id of the first inserted record, and there is no reliable way to get the ids of the other records (they might be guessable in simple cases, but it would break in a lot of clustering configs).
The only way around that would be to generate the primary key on the app side and load the records afterward or to not rely on that ability…
