You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » General Assistance (How Do I?) » Need a bit of SQL help
Register User    Portal Page     Forum List        Calendar     Active Topics     Search     FAQ
Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
4 registered (Jake, id242, SD, gliderdad), 32 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 01/24/07
Posts: 171
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#218405 - 10/25/08 11:38 AM Need a bit of SQL help
Flyin V Offline

member 		Registered: 06/05/06
Posts: 118
Hey nice forum people smile

Can you help me with an SQL statement to add all my existing users to a new group? The new groupID number is 13.

Thanks,
Jeff
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#218418 - 10/26/08 11:42 AM Re: Need a bit of SQL help [Re: Flyin V]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
If you're running MySQL 4.1+ you can use the following:

Sql Query:
insert into ubbt_USER_GROUPS 
(GROUP_ID,USER_ID) 
select '#', USER_ID from ubbt_USERS 
where USER_ID <> 1


Replace the # in that query with the new group number.
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image
Board Rules · Mark all read
Contact Us · UBBCentral · Top