【无标题】

数据库增删改查
1.增 insert into tables values (‘asd’,‘qwe’);
2.删 delete from table where a=‘q’;
3.改 update table set a=‘q’;
4.查 select * from table where a=‘lr’ and b=‘lm’;
a模糊查询
select * from table where a like ‘%T733.sh%’;
b联表查询条数
select count(*) from table a,tables b where a.trandate=b.trandate;
c按顺序排序
select *from table where a=‘ly’ order by Tran time desc