增
单条字符串要加单引号
insert into 表名(变量名) values ('值')
多条
insert into ProductInfos(ProNo,ProName,ProCount,TypeId) values(111,'小白',123,3)
删
delete from Test where Id=3
查
select UserId,UserName,Age from UserInfos
改
update Test set MName='bb' where Id=3