Copying Columns in a Table

[Master_Zen]

Is there a way to make a copy of an existing column within the same table? Not only that, is it possible to place that copy after another certain column?

If there's no direct way to do it, any other alternative would be welcomed.

Thanks! 🙂

[mjax]

This is the SQL you can use:

ALTER TABLE yourtable ADD COLUMN newcolumnname VARCHAR(255) NOT NULL AFTER aftercolumnname;
UPDATE yourtable SET newcolumnname=copyfromcolumnname;

[Master_Zen]

Worked perfectly, thanks!