alter table add column ... like this other column over here?

[fatkatie]

I want to alter a table and add a new column.

 

I want to add a second email address column and I want the design of this new column to match with the first.  For example, if

email varchar(128) default null

then I want the new column the "same" as in:

email2 varchar(128) default null

Can column design values be copied in this way within the sql construct?

 

Can column design values be collected from another separate table?

[Barand]

You can create a table which has exactly the same structure as another

CREATE TABLE table2 LIKE table1;

I know of nothing similar down at the ADD COLUMN level.

Edited February 23, 2017 by Barand

[Jacques1]

Can column design values be copied in this way within the sql construct?

 

Why would you want that?

 

Duplicating columns is a bad sign and sounds like the usual MySQL-is-Excel confusion.

[fatkatie]

Thank you for your comment.