changing the order of rows in a table

[Robert_Blackwel]

Will this "break" anything?
I have a table in my dbase that someone made but they kind of created it backwards IMO.

CREATE TABLE abilities (
category varchar(25) default NULL,
requirements varchar(75) default NULL,
target varchar(14) default NULL,
classification varchar(7) default NULL,
rank int(2) default NULL,
duration int(4) default NULL,
cooldown varchar(7) default NULL,
delay varchar(7) default NULL,
effect tinytext,
mana int(5) default NULL,
damage int(4) default NULL,
element varchar(25) default NULL,
type varchar(25) default NULL,
g_price int(2) default NULL,
c_price int(2) default NULL,
s_price int(2) default NULL,
sp_price int(3) default NULL,
class varchar(75) default NULL,
level int(2) default NULL,
icon varchar(100) default NULL,
name varchar(30) default NULL,
id int(4) NOT NULL auto_increment,
PRIMARY KEY (id)
) TYPE=MyISAM;

I'm using MySQL Front 3 and I was planning on rearranging the table so when I'm in dataview, I see id name etc first.

I'm pretty sure the answer to my question is "it's fine" as long as I'm not changing any of the names and stuff.

I just need some reassurance 🙂
Thanks

[dnast]

You can use ALTER TABLE MODIFY to change the position of the field.

an example is:

ALTER TABLE abilities
MODIFY id INT(4) NOT NULL auto_increment
FIRST

I'd try it out on a test table before you jump into it, though.

[Robert_Blackwel]

great, thanks.