sql基本使用语句

1、查询 SELECT
select * from 表名
查询某一个字段
SELECT a FROM 表名
按照某个字段降序查询
SELECT * FROM 表名 ORDER BY a desc
正序查询
SELECT * FROM 表名 ORDER BY a asc
条件查询
SELECT * FROM 表名 WHERE AID = ‘FJDL1021001’
2、删除 DELETE
DELETE FROM 表名 WHERE ARZZLMC = ‘交强险第五年’
3、修改UPDATE
UPDATE 表名 set AHKRKHM = ‘黄药师PART_FAIL’ WHERE ASQBH = ‘LB-ZJHZ123000056’;
4、插入insert into
insert into 表名(AID, ATABLENAME, ADOCUMENTNO, ATATTACHCLASS, ATATTACHSUBCLASS, AFILENAME, AFILETYPE, ANEWFILENAME, ANEWFILEPATH, AFILENAMEC, AFILETYPEY, AFILENAMEY, AFILEPATH, AFILENAMES, AUPIP, AUPTIME, AUPOPER, AFLAG, ASTAT, AOPER, AOPERTIME, ASLTLJ, ASLTMC, FLASHLJ, FLASHMC, AUPDATE, AYWZJ) values (‘8b22d7f66914a8e5016927cf376d0319’, ‘TASSET_RC_DAY_LOG’, ‘LB-ZJHZ123000013’, ‘FJDL409100’, ‘10’, ‘127-15012611014g18.jpg’, ‘jpg’, null, ‘20190226/LB-ZJHZ123000013/FJDL409100/10/source/20190226111805356001005360122414.jpg’, null, null, null, null, null, null, ‘11:18:05’, null, 0, null, null, null, ‘image’, null, ‘20190226/LB-ZJHZ123000013/FJDL409100/10/source/20190226111805356001005360122414.jpg’, null, ‘2019-02-26’, null);
5、left join 左连接
SELECT sum(cost.FRZE ) FROM lb_apply_contract_info contract
left join lb_apply_cost cost on contract.ASQBH = cost.ASQBH

WHERE contract.AHTZT =‘2’ AND contract.DHTFKRQ IS NOT NULL