创建表 create table student( name varchar(30), id int, score double, classmate varchar(10) ); 查询数据 select * from user; 插入条数据 insert into user (name,pwd) values (‘小张’,‘999’); 修改数据 update user set pwd=‘5555’ where name=‘小红’; 删除数据 delete from user where name=‘小张’;