2023.2.8日学习内容

数据库的常用语句

SELECT 选取：

SELECT * FROM table_name

WHERE 过滤：

SELECT column1, column2, ...

FROM table_name

WHERE condition;

UPDATE 更新数据：

UPDATE table_name

SET column1 = value1, column2 = value2, ...

WHERE condition;

INSERT INTO 添加数据：直接添加类似于全参构造方法

INSERT INTO table_name

VALUES (value1,value2,value3,...);

INSERT INTO 添加数据：选取某些属性添加

INSERT INTO table_name (column1,column2,column3,...)

VALUES (value1,value2,value3,...);

DELETE 删除数据：

DELETE FROM table_name

WHERE condition;

AND & OR 逻辑与，逻辑或

SELECT * FROM WebsitesWHERE country='CN'AND alexa > 50;

ORDER BY 排序

• ASC：表示按升序排序。

• DESC：表示按降序排序。