Re: CSV into mysql - How do I overwright existing data ?

[Gabriel Birke]

Don Beesing has already told you how to replace existing data. Now something about the notices: A notice is generated when you try to access an array element with a nonexistant index. From your message I conclude that there is a line in your CSV file that has only two fields - the other, nonexisting fields show up as notices - this is not critical for the code because the empty data won't produce an sql error because it is quoted.

You have two options avoiding the notices:
1. check your CSV file
2. insert the line "error_reporting(E_ALL ^ E_NOTICE);" before importing the csv

describe europe Ltd.
Ruby on Rails, PHP and MySQL programming solutions
http://www.d-scribe.de/