新建表
CREATE table teacher (
      id    INT(4) NOT NULL UNIQUE PRIMARY KEY AUTO_INCREMENT,
      num   INT(10)  NOT NULL UNIQUE,
      name  VARCHAR(20) NOT NULL,
      sex   VARCHAR(4)  NOT NULL,
      birthday   DATETIME,
      address    VARCHAR(50)
      );
      
单条数据插入      
INSERT into  teacher values (1,1001,'张三','男','1984-11-08','北京市昌平区');

同事插入多条数据
insert into teacher  values  
         (2,1002,'李四','女','1970-01-21','北京市海淀区'),
         (NULL,1003,'王五','男','1976-10-30','北京市昌平区'),
         (NULL,1004,'赵六','男','1980-06-05','北京市顺义区');

更该id1行中 
update  teacher set  birthday='1982-11-06'    where id=1; 

更新列数据
update  teacher set  address=null;

也可以按照值进行详细的删除
delete from teache where nane='张三';

删除num的1002行
delete from teacher where num=1002;

删除两张表中相同的数据 
delete table1,,table2 from table1,,table2  where  table1.file=table2.file;

清空表
delete  from teacher;