[Squid44th]

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.

[gordypordy]

If you're gonna be chopping/changing perhaps phpMyAdmin might be of use.

You would either have to install it on your site/server, or if you're with a REALLY GOOD HOST (hint: see signature) It would come with the package.

You can get the gen and download for it at:

www.phpmyadmin.net/