Must-Knows
If any of these identifiers are used as reserved words for database names, table names, column names, function names, or view names, they need to be enclosed with default escape characters:
Identifier: ` backticks
For example: hour -> `hour`
create table `hour` (
id string,
`asc` int
)
hour and asc are keywords. If you need to create columns with these names, you must enclose them in backticks.
Key Reserved Words
A
ALL
ALTER
AND
ANY
AS
AUTHORIZATION
B
BETWEEN
BOTH
BY
C
CALL
CASE
CAST
CHECK
CLUSTER
COLLATE
COLUMN
CONSTRAINT
CREATE
CROSS
CUBE
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
D
DEALLOCATE
DEFAULT
DELETE
DESCRIBE
DISTINCT
DISTRIBUTE
DROP
E
ELSE
END
ESCAPE
EXCEPT
EXECUTE
EXISTS
EXPLAIN
EXTRACT
F
FETCH
FILTER
FOR
FOREIGN
FROM
FULL
FALSE
G
GRANT
GROUP
GROUPING
H
HAVING
I
IN
INNER
INSERT
INTERSECT
INTERVAL
INTO
IS
J
JOIN
L
LATERAL
LEADING
LEFT
LIKE
LIMIT
LOCALTIME
LOCALTIMESTAMP
M
MERGE
MINUS
N
NATURAL
NEW
NEXT
NORMALIZE
NOT
NULL
O
OFFSET
ON
ONLY
OR
ORDER
OUTER
OVER
OVERLAPS
P
PARTITION
PATTERN
PERCENTILE_CONT
PERCENTILE_DISC
PERMUTE
PREPARE
PRIMARY
R
RANGE
RECURSIVE
REFERENCES
RIGHT
ROLLUP
ROW
ROWS
S
SELECT
SEMI
SESSION_USER
SET
SOME
T
TABLE
THEN
TIME
TO
TRAILING
TRUE
U
UESCAPE
UNION
UNIQUE
UNKNOWN
UNNEST
UPDATE
USER
USING
V
VALUES
W
WHEN
WHERE
WINDOW
WITH
WITHIN