开发中最基本的对数据的增删改查SQL
1.增加
insert into [表名] (列名) values(列值);
2.删除
delect from [表名] [where<删除条件>]
3.修改
update [表名] set [ 列名 = <修改值> ] [where<修改条件>]
4.查询
select [列名] from [表名] [where<查询条件>] group by [分组条件] having [过滤条件] order by [过滤条件]
注意:查询时的书写顺序、和查询时的执行顺序不一致!