SQL查询语句整理集合

基础查询

SELECT * FROM [表名]

查询对应某一列

SELECT [A1] FROM [表名] 

查询某值所对应的列名匹配

SELECT A1 FROM [表名] WHERE a1='id' 

查询两个值所对应的数据

SELECT A1 FROM [表名] WHERE A1='id' and B1='name' 

查询的结果以某列倒序排列

SELECT * FROM [表名] ORDER BY B1 DESC
//ASC为正序排列

直接按顺序列添加数据

INSERT INTO [表名] VALUES (a1,b1,c1)

按对应值添加数据

INSERT INTO [表名] (A1,B1,C1) VALUES (a1,b1,c1)

修改数据

UPDATE [表名] SET B1='b1',C1='c1' WHERE A1='a1'

删除对应数据

DELETE * FROM [表名] WHERE A1='a1'