SQL Altering excisting table

Add a field :

ALTER TABLE tablename ADD newfieldname newfieldattributes AFTER existingfield

Altering individual field:

ALTER TABLE t1 CHANGE b b BIGINT NOT NULL;