SQL/MySQL/Table Index/Default Value
Specifying Default Values 1
<source lang="sql">
/* mysql> DROP TABLE Employee; Query OK, 0 rows affected (0.01 sec) mysql> CREATE TABLE Employee (
-> Name VARCHAR(50) NOT NULL, -> Phone VARCHAR(15) DEFAULT "Unknown Phone" NOT NULL);
Query OK, 0 rows affected (0.06 sec) mysql> Describe Employee; +-------+-------------+------+-----+---------------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------------+-------+ | Name | varchar(50) | | | | | | Phone | varchar(15) | | | Unknown Phone | | +-------+-------------+------+-----+---------------+-------+ 2 rows in set (0.00 sec) mysql> INSERT INTO Employee (Name, Phone) VALUES ("Joe Wang", "666 2323"); Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO Employee (Name) VALUES ("Joe Wang"); Query OK, 1 row affected (0.01 sec) mysql> INSERT INTO Employee (Name, Phone) VALUES ("Joe Wang", NULL); ERROR 1048 (23000): Column "Phone" cannot be null mysql> select * from Friday; ERROR 1146 (42S02): Table "t.friday" doesn"t exist
- /
DROP TABLE Employee; CREATE TABLE Employee (
Name VARCHAR(50) NOT NULL, Phone VARCHAR(15) DEFAULT "Unknown Phone" NOT NULL);
Describe Employee; INSERT INTO Employee (Name, Phone) VALUES ("Joe Wang", "666 2323"); INSERT INTO Employee (Name) VALUES ("Joe Wang"); INSERT INTO Employee (Name, Phone) VALUES ("Joe Wang", NULL); select * from Friday;
</source>