Uninstalling queries

[Edison Chen]

Quick question.

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

[Modin]

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?

[Edison Chen]

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'

[Modin]

run the query ...

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

that'll change that field for ya

[Edison Chen]

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

[Modin]

great to hear

your welcome

[Edison Chen]

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

[Modin]

Like this

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

[Edison Chen]

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

[Modin]

glad I could help mate