i have a table in a database, with the contents imported from a .csv file ( from excel).after the import i have added a numeric id field ( with autoincrement). can i still add to the table from other csv files (with the same structure of course), because they do not have the last numeric field? this is my problem. is mysql smart enough, or is there a scripting method to add the field after i import the data from the .csv file ? in would need the id field because i can modify things faster