mysql> create table Teachher(? ? -> id int(4) primary key not null unique auto_increment,? ? -> num int(10) not null unique,? ? -> name varchar(20) not null,? ? -> sex varchar(4) not null,? ? -> birthday datetime,? ? -> address varchar(59)? ? -> );Query OK, 0 rows affected (0.67 sec)mysql> desc Teachher;+----------+-------------+------+-----+---------+----------------+| Field ? ?| Type ? ? ? ?| Null | Key | Default | Extra ? ? ? ? ?|+----------+-------------+------+-----+---------+----------------+| id ? ? ? | int(4) ? ? ?| NO ? | PRI | NULL ? ?| auto_increment || num ? ? ?| int(10) ? ? | NO ? | UNI | NULL ? ?| ? ? ? ? ? ? ? ?|| name ? ? | varchar(20) | NO ? | ? ? | NULL ? ?| ? ? ? ? ? ? ? ?|| sex ? ? ?| varchar(4) ?| NO ? | ? ? | NULL ? ?| ? ? ? ? ? ? ? ?|| birthday | datetime ? ?| YES ?| ? ? | NULL ? ?| ? ? ? ? ? ? ? ?|| address ?| varchar(59) | YES ?| ? ? | NULL ? ?| ? ? ? ? ? ? ? ?|+----------+-------------+------+-----+---------+----------------+6 rows in set (0.01 sec)mysql> insert into Teachher(num)? ? -> values('2513');ERROR 1364 (HY000): Field 'name' doesn't have a default valuemysql> insert into Teachher(num)? ? -> values(2513);ERROR 1364 (HY000): Field 'name' doesn't have a default value
添加回答
舉報
0/150
提交
取消