I'm very new to MySQL -- so, your help is very much appreciated.
I have a table that has 50 fields. 2 of the fields are primary (named: item_number and catalog_year). There are about 1200 different unique items on this table.
Now, what I basically need to update is the last field (field 50) which is called pkg_options.
I need to change all the entries inside this particular field(pkg_options) to a new entries.
I have created a text file with 2 columns separated with comma. The first column represent the Item Number and the second is for Packaging Options(pkg_options).
So it looks like this,
and so on...
How do I update this field in phpmyadmin? How do I import this text file I created so I dont
have to change each row at a time? Imagine this could take me a month or so... pls help.
A step by step tutorial would be much appreciated. Thanks very much!