1.2.4.4.Default value

• 設定某欄位的預設值

alter table studentsdetails alter column mobile set default 'no mobile';

• 建立有預設值的table

Create table profile (id INT(11) auto_increment primary key, name VARCHAR(100) not null, designation VARCHAR(100) DEFAULT 'student', created_date TIMESTAMP);