插入语句:
(一)SQL查询语句
查询全表:select * from Table
根据字段条件查询:select * from Table whereColumn = '条件'
根据同时满足多个字段条件查询:select * from Table whereColumn = '条件' andColumn = '条件' and ...
根据多个字段中的条件查询:select * from Table whereColumn = '条件' or Column = '条件' or ...
查询表中某个字段:select Column,Column,... from Table
例子:select *from SP
(二)SQL插入语句:insert into Table (Column,Column,...) values ('Content','Content',...)
例子:insert into SP(rEMP,rETP,rActHWC,rActCDA) values (11,11,11,11)
(三)SQL删除语句
根据字段中的条件删除行:delete from Table where Column = '条件'
根据多个字段中的条件删除:delete from Table where Column = '条件'' andColumn = '条件' and ...
根据同时满足多个字段中的条件删除:delete from Table where Column = '条件' orColumn = '条件' or ...
根据同个字段中不同条件删除多行:delete from Table where Column in (条件,条件,...)
例子:delete from SP where rEMP=11
(四)SQL修改语句
修改全表字段内容:update Table set Column = 'Content' , Column = 'Content' , ...
根据字段条件修改该行的字段内容:
update Table set Column = 'Content' ,Column = 'Content' , ...where Column = '条件'
根据同时满足多个字段条件修改字段内容:
update Table set Column = 'Content' ,Column = 'Content' , ...where Column = '条件' and Column = '条件' and ...
根据多个字段条件修改字段内容:
update Table set Column = 'Content' ,Column = 'Content' , ...where Column = '条件' orColumn = '条件' or ...
例子:update SP set rEMP=15 where rEMP=10