We can do this easily by using COMMENT attribute in alter command. Ex- Find the below alter command which will add "address" column to "user" table after "country" column.

MYSQL-DDL-COMMANDS-ASSIGNMENT-1 Creating a database named School and performing all the DDL commands (CREATE, ALTER, DROP, RENAME, TRUNCATE) for the table named STUDENT with fields: Roll_No, ...