Inserting into specific column in table

Forum Moderators: open

Message Too Old, No Replies

Inserting into specific column in table

harryhermit

6:16 pm on Jan 18, 2007 (gmt 0)

Hi, I have a mysql db and I'm trying to insert model numbers from a csv file into a specific column in a db table. Is there a way to do this through phpmyadmin?

FalseDawn

9:23 pm on Jan 18, 2007 (gmt 0)

Is the table already populated?

If so, does the csv file have model IDs that you need to match to those on your table (or is the model code the PK?)? In this case, you might need to write a script to create multiple UPDATE statements.

If not, you may be able to import the csv file into your table, but any other columns will be NULL.