PDA

View Full Version : Mysql Query Help....


ladyfyre
06-18-2002, 04:10 PM
Could one of you help me structure a query?

I have over 250 different forums, and each of them seems to be set to use my "main" style theme, and is over-riding user selected styles. So....i need to the value of the styleoverride field (in the forum table) to 0 for every forum (i am fairly certain this is it)....but was wanting to use a query instead of trying to use the CP for updating ALLLLLL of them by hand...

can one of you tell me how to structure the query to accomplish this?

Would this be correct?

UPDATE forum SET styleoverride=0;

Xenon
06-18-2002, 04:22 PM
yep, this query is correct

ladyfyre
06-18-2002, 04:24 PM
thanks :)

Wooohoooo!!!!! maybe i am not as hopeless as i thought.

Xenon
06-18-2002, 04:38 PM
training creates masters ;)
(german speech badly translated ;))

little thing:
in SQL you don't need to end a query with ;