Tables Part 3 – Alter

/* Add New Password Field */
ALTER TABLE students ADD password varchar(255);

/* Add Username Field After name Field */
ALTER TABLE students ADD username varchar(255) AFTER name;

/* Add test Field As First Field */
ALTER TABLE students ADD test varchar(255) FIRST;

/* Delete Field last */
ALTER TABLE student DROP last;

/* Change Field Location And Type */
ALTER TABLE students CHANGE username username varchar(255) AFTER email;

/* Change Field Type */
ALTER TABLE students CHANGE test test char(50);

/* Modify Field Type */
ALTER TABLE students MODIFY test varchar(255);