CREATE TABLE address(id int not null, street varchar(255), postcode varchar(10), town varchar(30) default "Harrow");
The DEFAULT keyword used in this statement is followed by the default value “Harrow” for the town name column in the Address table. In this case, if Mr. Carl Merkel wants to insert data into this table, then there is no need to type “Harrow” for any customer who lives in this town as it will be inserted automatically.