select 基本常用语法

最新推荐文章于 2022-04-14 18:21:47 发布

躲不过这哀伤

最新推荐文章于 2022-04-14 18:21:47 发布

阅读量109

点赞数

原文链接：http://www.cnblogs.com/wbcms/archive/2007/08/23/866890.html

版权

***********************************************************

SELECT语法：(基本)

*************************************************************
**********************************************************
SELECT [DISTINCT]
(column [{, column } ] )| *
FROM table [ { , table} ]
[ORDER BY column [ASC] | [DESC
[{ , column [ASC] | [DESC } ] ]
WHERE predicate [ { logical-connector predicate } ];
------------------------------------------------------

INSERT语法：

INSERT INTO table
[(column { ,column})]
VALUES
(columnvalue [{,columnvalue}]);
------------------------------------------------------

UPDATE语法：

UPDATE table
SET column = value [{, column = value}]
[ WHERE predicate [ { logical-connector predicate}]];
------------------------------------------------------

DELETE语法：

DELETE FROM table
[WHERE predicate [ { logical-connector predicate} ] ];
------------------------------------------------------

转载于:https://www.cnblogs.com/wbcms/archive/2007/08/23/866890.html