importing and adding csv files

[sundogro]

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

[Anon]

I'm sure there is a better way to do this, but this will work for you.

Create a new table that looks like your csv file. Then import into that table. Now do an insert in your ID'd table selecting your values from your new table. Finally delete everything from your new table and keep it around for when you need to do this again.

INSERT INTO id_table (col1,col2,col3, ID) VALUES
SELECT col1,col2,col3,NULL FROM new_table;

Or something like that should do the trick.