I ran into a problem where one version of my database has a column that is in the wrong position. Is there a way in mysql to re-index or exchange columns?
Worked, thanks! I think I could use modify as well and not need the new_col name. You guys are way faster than Google and MySQL's website!
Peter Turner
2009-11-20 15:04:07