Quick MYSQL Question... - vb.org Archive

		vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
Quick MYSQL Question...

Reply

#1

Old

02-21-2007, 05:21 AM

noonespecial noonespecial is offline

noonespecial is offline

Join Date: Nov 2002

Posts: 250

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

Quick MYSQL Question...

I have a column in the mysql table "events" called "rsvp" currently the value for most of the rows is set to "0" - however I want to change all of them to "1" ... what's the best way to do this?

There's a query I can run, right?

Reply With Quote

#2

Old

02-21-2007, 11:49 AM

nico_swd

nico_swd is offline

Join Date: Dec 2005

Location: Spain

Posts: 170

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

Code:

UPDATE events SET rsvp = 1

Reply With Quote

#3

Old

02-21-2007, 11:13 PM

noonespecial noonespecial is offline

noonespecial is offline

Join Date: Nov 2002

Posts: 250

Благодарил(а): 0 раз(а)

Поблагодарили: 0 раз(а) в 0 сообщениях

Default

Thank you

Reply With Quote

Reply

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT. The time now is 12:05 PM.