Copy/Move Column

[richarddunnebsc]

phpMyAdmin only allows copy/move for tables, that I'm aware of. Columns can only be moved within a table for column ordering. For normalization purposes, instead of having to drop a column from one table, then add/create the same column in another table, it would be really useful to be able to copy and/or move one or more columns from one table to another.

[williamdes]

Bonjour @richarddunnebsc
That seems like an idea that could be helpful but I am not sure we should implement it because of the complexity it represents
What do you think about it @MauricioFauth ?

[MauricioFauth]

I think that is a good idea. I was thinking in something similar recently, but it was more like a diff tool for table structures.
To be able to copy/move, it should create the appropriate ALTER TABLE statements. However, I don't know if will be possible to move the rows as well.

[williamdes]

I think that is a good idea. I was thinking in something similar recently, but it was more like a diff tool for table structures. To be able to copy/move, it should create the appropriate ALTER TABLE statements. However, I don't know if will be possible to move the rows as well.

Yeah, the data part is tricky but indeed moving or copying the column is definitely an idea

[williamdes]

This may be related to this old issue #6317