Request for phpmyadmin assistance to update a mysql db table.
I have a db table that has 12,000 "year" posts ranging from 1999 to 2005. I need each year/POST to be updated WITH 2 years to insteead range from 2001 to 2007.
Possible alternative to updating directly in phpmyadmin is to correctly upload an already updated table (in excel... which was downloaded from phpmyadmin and updated by me. This file now already has correct years across all 12,000 posts). I am however unable to locate a way to properly import and update the posts of a single db table via Excel.
We are also looking to establish a relationship as some more work will come from this as we are starting with some db updates/work. This is just the first task. Please quote only on the request described above however.