SQL 速查表

带语法和示例的可搜索SQL命令参考。

SELECT

SELECT * FROM tableAll columns

SELECT col1, col2 FROM tableSpecific columns

SELECT DISTINCT col FROM tableUnique values

SELECT col AS alias FROM tableColumn alias

SELECT COUNT(*) FROM tableCount rows

SELECT AVG(col) FROM tableAverage

SELECT SUM(col) FROM tableSum

SELECT MAX(col), MIN(col) FROM tableMax and Min

WHERE / ORDER

WHERE col = 'value'Equality

WHERE col != 'value'Inequality

WHERE col IN (1, 2, 3)In list

WHERE col BETWEEN 10 AND 20Range

WHERE col LIKE '%text%'Pattern match

WHERE col IS NULLNull check

ORDER BY col ASCAscending

ORDER BY col DESCDescending

LIMIT 10 OFFSET 20Pagination

JOIN

INNER JOIN t2 ON t1.id = t2.idMatching rows

LEFT JOIN t2 ON t1.id = t2.idAll left + matching right

RIGHT JOIN t2 ON t1.id = t2.idAll right + matching left

FULL OUTER JOIN t2 ON t1.id = t2.idAll rows both tables

CROSS JOIN t2Cartesian product

GROUP BY

GROUP BY colGroup rows

GROUP BY col HAVING COUNT(*) > 1Filter groups

GROUP BY col1, col2Multiple columns

Modify Data

INSERT INTO t (col) VALUES ('val')Insert row

UPDATE t SET col='val' WHERE id=1Update rows

DELETE FROM t WHERE id=1Delete rows

TRUNCATE TABLE tDelete all rows

UPSERT / INSERT ... ON CONFLICTUpsert

DDL

CREATE TABLE t (id INT PRIMARY KEY, name TEXT)Create table

ALTER TABLE t ADD COLUMN email TEXTAdd column

DROP TABLE tDrop table

CREATE INDEX idx ON t(col)Create index

CREATE VIEW v AS SELECT ...Create view

加载工具中...

关于此工具

带语法和示例的可搜索SQL命令参考。

SQL 速查表

SELECT

WHERE / ORDER

JOIN

GROUP BY

Modify Data

DDL

相关工具

关于此工具

SELECT

WHERE / ORDER

JOIN

GROUP BY

Modify Data

DDL