Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
sql help for the syntactically challenged
#215120 07/03/2008 7:11 PM
Joined: Jul 2006
Posts: 62
New Zealand
C
Carte Blanche
Offline
journeyman
Carte Blanche
journeyman
C Offline
Joined: Jul 2006
Posts: 62
New Zealand
Hi,

I want to change the value for 1 field in a table for all records in that table.

Specifically, in the Forum_permissions table, I think the default for the field ad_island is 0, I want to update every record so that the value for that field is 1.

Which in truth, it should be. Having that value set to one for every group is fine and won't change anything unless you actually designate a post island to be displayed in the forum details side.

Anyway, could someone help me out with the sql statement for that?
Re: sql help for the syntactically challenged
Carte Blanche #215121 07/03/2008 7:19 PM
Joined: Jul 2006
Posts: 62
New Zealand
C
Carte Blanche
Offline
journeyman
Carte Blanche
journeyman
C Offline
Joined: Jul 2006
Posts: 62
New Zealand
Bleh, nevermind, got it. I'm a lazy bastard is all tongue
Re: sql help for the syntactically challenged
Carte Blanche #215142 07/04/2008 11:28 AM
Joined: Apr 2007
Posts: 3,940
Likes: 1
SoCal, USA
SD Offline
Former Developer
SD
Former Developer
Offline
Joined: Apr 2007
Posts: 3,940
Likes: 1
SoCal, USA
SQL Query
UPDATE ubbt_USERS u, ubbt_USER_PROFILE up
SET u.USER_LAZY_BASTARD=1
WHERE u.USER_ID=up.USER_ID
AND up.USER_DISPLAY_NAME='Carte Blanche'

laugh
Re: sql help for the syntactically challenged
SD #215242 07/06/2008 9:56 PM
Joined: Jul 2006
Posts: 62
New Zealand
C
Carte Blanche
Offline
journeyman
Carte Blanche
journeyman
C Offline
Joined: Jul 2006
Posts: 62
New Zealand
/facepalm so true.

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
2 members (Nightcrawler, Ruben), 524 guests, and 148 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)