数据库系概论(一)

//创建表
create table Student(
  sname nchar(10)
)
//插入行
insert into Student 
  values('zhang')
//插入行中指定的元素
insert into Student(sname)
  values('zhang')
//根据条件删除行
delete from Student where sname='zhang'
//根据条件更新行
update Student set sname='li' where sname='zhang '