how to add a column to a table after a specific column

alter TABLE student add column age int(4) after name