Add Column to Existing MySQL Table
- Lucas
- October 20, 2012
To add the“age” column of type “int (11)” to the“student” table, simply use the following SQL query: ALTER TABLE aluno ADD idade int(11) the above query will add the column“age” last column, if you want to define the position of the column use the following SQL query: ALTER TABLE aluno ADD idade int(11) AFTER nome