Mysql数据库增删改查最简单写法

添加数据

insert into User values(1,"lirixing","boy");

查询

select * from User;

更新

update User  set name="liri" where id=1;

删除

delete from User;

查询总条数

select count(1) from User;

查询一个数的和

select sum(id) from User;