Is there any way to have MySQLBulkWriter to return the ids of the newly added records.
So for example I have a table like so:
| id | name | last | company | position |
and I have a flat file that has data like so:
^^Joe^^Johnson^^Company ABC^^Manager^^
^^Mike^^Mills^^Company 123^^Staff^^
^^Dale^^Dwells^^Company ABC^^Staff^^
So I have my bulk writer setup to read it with the ^^ delimeter and it inserts the records perfectly
| id | name | last | company | position |
| 5 | Joe | Johnson | Company ABC | Manager |
| 6 | Mike | Mills | Company 123 | Staff |
| 7 | Dale | Dwells | Company ABC | Staff |
Is there anyway that the bulkwriter can return to me a flatfile like this
5
6
7
or maybe
5,6,7
?
So for example I have a table like so:
| id | name | last | company | position |
and I have a flat file that has data like so:
^^Joe^^Johnson^^Company ABC^^Manager^^
^^Mike^^Mills^^Company 123^^Staff^^
^^Dale^^Dwells^^Company ABC^^Staff^^
So I have my bulk writer setup to read it with the ^^ delimeter and it inserts the records perfectly
| id | name | last | company | position |
| 5 | Joe | Johnson | Company ABC | Manager |
| 6 | Mike | Mills | Company 123 | Staff |
| 7 | Dale | Dwells | Company ABC | Staff |
Is there anyway that the bulkwriter can return to me a flatfile like this
5
6
7
or maybe
5,6,7
?
Comments (2)