MySQL增删改查常用SQL

# 创建数据库
create database mydatabase;
# 创建表
create table stu(id int(10),name varchar(10),class varchar(10));
# 新增数据
insert into stu values('1','zhangsan','1314');
# 查看数据
select * from stu where id=1;
# 修改数据
update stu set name='wangwu' where id=1;
# 删除数据
delete from stu where id=1;