简单常用的SQL命令

order by desc：按照降序对记录排序

select company,ordernumber from orders order by company

SELECT Company, OrderNumber FROM Orders ORDER BY Company DESC

向表中插入一条数据：

INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....)

INSERT INTO 表名称 VALUES (值1, 值2,....)

INSERT INTO Persons VALUES (‘Gates‘, ‘Bill‘, ‘Xuanwumen 10‘, ‘Beijing‘)

update语句：

update <表名> set <列名>＝新值 where 列名＝某值

update class set name＝Joy where id ＝3

UPDATE Person SET Address = ‘Zhongshan 23‘, City = ‘Nanjing‘ WHERE LastName = ‘Wils‘

delete 语句：用于删除表中某一行

delete from class where city=‘beijing‘

---恢复内容结束---

简单常用的SQL命令

标签：--   ast   语句   drop   database   表名   city   重复   from