Appending csv on upload

[Jay Webb]

General question, when uploading csv files, I would like to add about 3500 new name and dates and other stuff to there table all proper, can the csv uploaded append if I start with the last id number or will I need to append it myself and then re-upload a new csv file. Would hate to screw up my data and go down for hours.

[pbottcher]

Hi,

I would assume that if the ID is autoincremented, and you omit the id in the uploaded data, it will just append the new records.
If your id number is manually handled, then you need to provide the correct number of course.

[Jay Webb]

Thanks for responding, yea ID are auto incremented and I could provide the next in line ID, so if last ID is 2656 if I started at 2557 to 6157 should
upload ok and not over write the current data or is it best to just leave out the ID and sql will auto increment the new stuff..

[pbottcher]

I would even let out the id field and let autoincrement the database.

[Jay Webb]

Well, I added the ID's and it worked flawlessly and it went easier then I thought it would, I tried a smaller set of 5 fields of 3186 records and that worked as well so ether way works, as long as no one is adding a record at the same time, but I was good there it's not public yet. I got one more
set of 9656 death records, a lot more died then were born between 1550 and 1850, wars, famine, plagues and still births took it's toll in 300 years.

Thanks for helping me out with this, you've been a great adviser.