Moving Fields Up/Down

[tomyknoker]

This is me just being picky but can I move fields up or down in my table? My table looks like this I want to move 1 and 2 up...

3 zsnfiCr0
4 1WESIC2t
1 YEHmyFsb
2 g5yCxSQt
5 vIlH9HrC
6 r5jIexHb
7 43Pw7LtL
8 k0BHs7a1
9 WxxiRNdb
10 OivjIiUP

[djr33]

ORDER BY fieldname at the end of your query.

If you are talking about the default, not sure there. You could make a new key.

In PHP managers (PHPMyAdmin etc) this is based on queries in that itself, so you might not be able to use it in there, or get it to work like this, etc.

you could also grab all the data, using ORDER BY, then delete that table, etc. then put the contents back in. Careful on this though, if it did happen to lose it before resetting.

[tomyknoker]

Heya dj... Yea I'm talking about the default...

I guess I'll try the last option... Also when I insert fields, then delete them the auto_incremement starts from the previous data, can you reset the auto_inrement field?

[djr33]

The auto increment is.... automatic. You can't really control that. You could do the same and just reset it by resetting the whole thing. You could see what happens with deleting that column then adding it back in, but the order might be messy. Not sure there.