新建表
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;
转载于:https://blog.51cto.com/kexl908/884926