SQL DEFAULT

SQL DEFAULT is used to insert a default value into a column.

The default value will be added to all new records, if no other value is given.

Example

CREATE TABLE users(uid int NOT NULL,name varchar(255) NOT NULL DEFAULT ‘phpcode’)