1.2.2.16.Altering Table Structure - ALTER TABLE

• 修改column

  • 例如將email改為unique

    alter table studentsdetails modify column email VARCHAR(100) unique;

  • 將email改為unique not null

    alter table studentsdetails modify column email VARCHAR(100) unique not null;