My original data is stored in txt only(5 fields).
For some reason, I import 2 fields(url,description) recently for link checking purpose.
So I still need to import 3 other fields into the db. Since the data in mysql is not in original order or some links have been deleted. So your script must match the url field first and then insert 3 other fields to the correct row.
Here is sample txt db:
url,category,model name,des,sponsor,site
[login to view URL],category,name,desc,sponsorurl,sitename
[login to view URL],category,name,desc,sponsorurl,sitename
[login to view URL],category,name,desc,sponsorurl,sitename
[login to view URL],category,name,descsponsorurl,sitename