EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=596)
-   -   Changing an entire column (https://www.eqemulator.org/forums/showthread.php?t=30685)

ryder911 02-27-2010 12:25 AM

Changing an entire column
 
So I am trying to update the start zone on my server. I want all of the columns to be the same location - is there any way to do this other the by hand?

pfyon 02-27-2010 12:51 AM

Code:

update start_zones set start_zone=somezoneid
Since the above does not have a WHERE condition, it will apply it to every row in the table. You'll have to go through and make sure the rest of the columns in that table to make sure that it all works, but that's the syntax you'll need to use.

edit: You need to set somezoneid to whatever zone id you wanted to use.


All times are GMT -4. The time now is 08:42 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.