[Resolved] can I alter the columns in a table so they are ordered?

[BigBadKev]

Hi All,

I have a table that goes like the following

job_id
fname
ph
address
mobile
lname
bus_ph

Can I on the "fly" change it to

job_id
fname
lname
bus_ph
mobile
ph
address

Now remember the table and data are already created so is it possible to re-arrange the columns?

thanks in advance

BBK 🙂

[devinemke]

read this. the info is probably still relevant even if you are not using mySQL.

[Drakla]

If you do go for copying the table remember you've still got to add any indexes back to the table afterwards, as they're not done with a create / select query like

create table tablecopy as SELECT job_id,
fname,lname,bus_ph,mobile,ph,address FROM sometable;

drop table sometable;

rename table tablecopy to sometable;

[BigBadKev]

Thanks guys, i am going to work on this today.

BBK 🙂