Changing an entire column - EQEmulator Forums

		EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building
Changing an entire column

Home

Forums

Members List

Today's Posts

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Thread Tools

Display Modes

02-27-2010, 12:51 AM

pfyon

Discordant

Join Date: Mar 2009

Location: Ottawa

Posts: 495

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.

« 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 -4. The time now is 02:27 PM.

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.