Add attribute values directly into MYSQL for batch editing
I have run searches within the database for existing values and they only seem to appear in attributesearchindex and atDefault but I can seem to find how to bind atDefault to each product.
I admit I may have completely the wrong idea here to any help would be greatly appreciated.
Attributes on the other hand are much trickier and aren't really suitable for directly manipulating via the database. My advice here would be to handle this via the API - you would write a script to read the CSV, find the product and add the attribute values programmatically.