add new field in mysql table , its datatype and length must as same as other old field

Question

I want to add new column in mysql table but condition is new column must same as other old column(same table).

like old column have int data type and its length is 5

i want to add new column but new column datatype and length must same as old column.

i want to add new column but new column datatype and length must same as old column ? this is my question. please help me. — Vaibhav Jain, Sep 28 '14 at 06:50
myold column(field) is = age1 int 5 i want to create new column(field) = age2 int 5 — Vaibhav Jain, Sep 28 '14 at 06:52

score 1 · Answer 1 · edited May 23 '17 at 12:13

1

You can add a column like this:

ALTER TABLE `table_name` ADD COLUMN `age2` INT;

The "length" doesn't matter. INT is INT. It's a common misconception that the argument to an INT type is some sort of "length" or "size". It's not.

edited May 23 '17 at 12:13

Community

answered Sep 28 '14 at 07:26

Bill Karwin

1 Answers1