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