Need to update a database table in one of 2 ways
1) need to delete a column and add one in its place
// delete column
$query4 = "????????"
// add shipping field to table
$query5 = "ALTER TABLE ".DB_PREFIX."table ADD COLUMN shipping double(10,2) AFTER column";
or
2) change column to reflect something else
// change taxable field to shipping field in table
$query4 = "ALTER TABLE ".DB_PREFIX."table ????????";
Ive looked at mysql.com and other places, but can't find anything on deleting or changing column. Any help would be appreciated.