SQL Query Question (Easy I Think)

		vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
SQL Query Question (Easy I Think)

Thread Tools

Display Modes

08-08-2013, 03:19 PM

clayt101

Join Date: Jul 2012

Posts: 33

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

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

SQL Query Question (Easy I Think)

I have a column in my database called "timezoneoffset". I want to change the values of all the enteries from "0" to "-6".

How do I write that in SQL?

Thanks,
Clay

Edit: I am using phpMyAdmin

--------------- Added [DATE]1375983563[/DATE] at [TIME]1375983563[/TIME] ---------------

Got it I think!!!!

UPDATE user SET `timezoneoffset`="-6"

« 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 05:57 PM.

The Arcive of vBulletin Modifications Site.