添加、删除和修改数据的操作称为数据操作语言(DML)
(Data Manipulation Language)
--添加数据:
insert into teacher(tid,name,sex,birthday) values(‘T07’,‘何莉莉’,‘女’,‘2016-09-09’);
--更新数据:
update teacher set name='yes' where name='张无忌';
--删除数据:
delete from teacher where name='张无忌';
添加、删除和修改数据的操作称为数据操作语言(DML)
(Data Manipulation Language)
--添加数据:
insert into teacher(tid,name,sex,birthday) values(‘T07’,‘何莉莉’,‘女’,‘2016-09-09’);
--更新数据:
update teacher set name='yes' where name='张无忌';
--删除数据:
delete from teacher where name='张无忌';