//mysql的添、删、改、查询 以数据表student为例
//数据表的添加 insert
insert into student(sid,sex,age,addr,tel) values(1,'男',20,'南京',13612107569)
//数据表的删除 delete
delete from student where sid = 3
//数据表的修改 update
update student set sex,age,addr where sid = 3
//数据表的查询 select
select * from student //查询所有内容
select sex,age,tel from student where sid = 3//查询序号3的性别,年龄,电话号等
mysql代码实现数据库的增、删、改、查
最新推荐文章于 2024-04-18 17:42:53 发布