[Help] Organize rows

[xBlink]

I don't know if this is the right place to ask, but how do we orgazine rows in a table. Right now i'm working on k_npcpos and the 1st column is the zone id and i got all messed up. Isn't there a way to make them organized from 1 to 203...
thanks

 

[OMEGAbuffer]

Re: Organize rows

select * from k_npcpos order by k_npcpos

Copy the whole thing.

truncate table k_npcpos

Then, go open the k_npcpos and paste the code.

 

[xBlink]

thanks for your reply, but for some reason that's not working(when i try to run
select * from k_npcpos order by k_npcpos
):

Invalid column name 'k_npcpos'.


edit: ok, i just figured it out myself. thanks =)

 

[lollipop07]

I don't know if this is the right place to ask, but how do we orgazine rows in a table. Right now i'm working on k_npcpos and the 1st column is the zone id and i got all messed up. Isn't there a way to make them organized from 1 to 203...
thanks

sql query the table and use command:

order by zoneid
then execute it

or if you want to just display a certain zone's data sql query the table and use this command (example will be zone 201 = Colonyzone)

where (zoneid = '201')
then execute it

You can also then add order by npcid at the end to order it by npcid's like this

where (zoneid = '201') order by npcid
then execute it

to display more than 1 zone use:

where (zoneid = '201') or (zoneid = '21')
then execute

this will display only the colony zone and Moradon

 

[OMEGAbuffer]

thanks for your reply, but for some reason that's not working(when i try to run
select*from k_npcpos orderby k_npcpos
):

Invalid column name 'k_npcpos'.


edit: ok, i just figured it out myself. thanks =)

Whoops, gave you the wrong order by command. And,

You left out the spaces.

select * from k_npcpos order by zoneid