增:insert into 语句
删:delete语句
改:update语句
查:select语句
语法:
一、增加
insert into 表名 values(值1,值2,...)
列如:向表student中插入一条数据:
insert into studen(name,age,class)t values("张三",19,"三班")
二、删除
delete from 表名 where 列名=值
列如:删除student表中张三的数据
delete from student where name = "张三"
三、修改
update 表名 set 列名=值 where 列名=值
列如:修改student中张三的年龄为20
update student set age=20 where name= "张三"
四、查询
select 列名 from 表名 where +条件
列如:查询student中name为张三的学生信息
select name from student where name="张三"
select * from student where name="张三"
标签:语句,name,改查,spl,student,增删,where,select,列如 From: https://www.cnblogs.com/mmds/p/16933390.html