SQL 语句
格式化结果
📚 SQL 关键字参考
▼
查询
SELECT
FROM
WHERE
JOIN
LEFT JOIN
RIGHT JOIN
INNER JOIN
ON
GROUP BY
HAVING
ORDER BY
LIMIT
OFFSET
DISTINCT
AS
IN
NOT IN
BETWEEN
LIKE
IS NULL
IS NOT NULL
操作
INSERT INTO
VALUES
UPDATE
SET
DELETE FROM
TRUNCATE
定义
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE INDEX
DROP INDEX
PRIMARY KEY
FOREIGN KEY
UNIQUE
NOT NULL
DEFAULT
AUTO_INCREMENT
聚合
COUNT()
SUM()
AVG()
MAX()
MIN()
GROUP_CONCAT()