question about MySQL

[Dribbles]

I added a mod which made some new columns in my MySQL database under the field User. I am uninstalling the mod. How do I delete those columns? thnx (columns = pettype, petname, and petgender

[Xenon]

install phpmyadmin and delete em manually..

[mr e]

ALTER TABLE user DROP pettype, DROP petname, DROP petgender

[Dribbles]

thnx for the help, mr e :) Just curious, do the extra columns slow down the forum performance any?

[mr e]

i doubt 3 columns would slow it down a noticable amount

[Dribbles]

thnx man :) I'll be installing the RPG hack by bitsy soon ... so I'm gonna be probably adding 50 tables :)

[Bitsys]

Originally posted by Dribbles
thnx man :) I'll be installing the RPG hack by bitsy soon ... so I'm gonna be probably adding 50 tables :)

Well, its not quite that bad. Only 15 new tables and some modifications to the user table ;)

[Dribbles]

hehe