8,写出增,删,查,改的sql语句的表达格式。(还有一个写数据库的题,是根据表来写的,暂络)
答:假设有一个学生表Student,曾经有两个字段:学号id,姓名name
(1)增加:insert into Student vaules("01","张三")
(2) 删除:delete from student where id='01';或者truncate table student(全部删除)
(3)查询:select * from student;
(4) 修改:update student set name='李四'