PDA

View Full Version : SQL Query Question (Easy I Think)


clayt101
08-08-2013, 04:19 PM
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 1375983563 at 1375983563 ---------------

Got it I think!!!!

UPDATE user SET `timezoneoffset`="-6"