3.12 数据库的增删改查
本帖最后由 宝安22班-朱文峰 于 2022-3-13 11:33 编辑建表:create table student(
id int(10) primary key auto_increment,
name varchar(10) not null,
age varchar(3) default'18',
class int(5),
chinese int(5),
english float(4,2),
math float(4,2)
);
插入数据:
insert into student values('1','bao','25','1702','50','59.99','99.99');
修改数据:
update student set age='15' where id='1';
查询数据:
查询全部 select * from student;
查询全部姓名 select name from student;
查询id为1的学生的姓名 select name from student where id='1';
删除数据:
delete from student where id='3';
页:
[1]