Uninstalling queries
 

Quick question.

If we wish to get rid of a query, how do we uninstall it?

queries aren't installed, they are performed on a database to manipulate its data.

are you saying you ran a query and now want to reverse it? This depends on the query...

what query did you run?

ALTER TABLE user ADD userloc varchar(250) NOT NULL [original]

I want to change it to

ALTER TABLE user ADD userloc varchar(250) NOT NULL DEFAULT '0'

run the query ...

[SQL]
ALTER TABLE user CHANGE userloc userloc VARCHAR(250) DEFAULT '0' NOT NULL
[/SQL]

that'll change that field for ya :)

Thanks so much for your help. it's working now.

great to hear :)

your welcome

Sorry, apparently, the other query works better. How do I change it back to the initial query? Sorry for that.

Like this :)

[sql]
ALTER TABLE user CHANGE userloc userloc VARCHAR(250) NOT NULL
[/sql]

Thanks so much. It really helped. My forums just opened yesterday and doing pretty well on its first day already. Thanks to you. ;)

glad I could help mate :)