Database reserved words
If you use one of the following words in your query specification, you will get a warning that this might collide with the underlying database
- ACCESS
- ADD
- ALL
- ALTER
- ANALYZE
- AND
- ANY
- ARRAYLEN
- AS
- ASC
- ASENSITIVE
- AUDIT
- BEFORE
- BETWEEN
- BIGINT
- BINARY
- BLOB
- BOTH
- BY
- CALL
- CASCADE
- CASE
- CHANGE
- CHAR
- CHARACTER
- CHECK
- CLUSTER
- COLLATE
- COLUMN
- COLUMNS
- COMMENT
- COMPRESS
- CONDITION
- CONNECT
- CONNECTION
- CONSTRAINT
- CONTINUE
- CONVERT
- COUNT
- CREATE CROSS
- CREATE
- CURRENT
- CURRENT_DATE
- CURRENT_TIME
- CURRENT_TIMESTAMP
- CURRENT_USER
- CURSOR DATABASE
- DATABASES
- DATE
- DAY_HOUR
- DAY_MICROSECOND
- DAY_MINUTE
- DAY_SECOND
- DEC
- DECIMAL
- DECLARE
- DEFAULT
- DELAYED
- DELETE
- DESC
- DESCRIBE
- DETERMINISTIC
- DISTINCT
- DISTINCTROW
- DIV
- DOUBLE
- DROP
- DUAL
- EACH
- ELSE
- ELSEIF
- EMPTY
- ENCLOSED
- ESCAPED
- EXCLUSIVE
- EXISTS
- EXIT
- EXPLAIN
- FALSE
- FETCH
- FIELDS
- FILE
- FLOAT
- FLOAT4
- FLOAT8
- FOR
- FORCE
- FOREIGN
- FROM
- FULLTEXT
- GOTO
- GRANT
- GROUP
- HAVING
- HIGH_PRIORITY
- HOUR_MICROSECOND
- HOUR_MINUTE
- HOUR_SECOND
- IDENTIFIED
- IF
- IGNORE
- IMMEDIATE
- IN INDEX
- IN
- INCREMENT
- INDEX
- INFILE
- INITIAL
- INNER
- INOUT
- INSENSITIVE
- INSERT
- INT
- INT1
- INT2
- INT3
- INT4
- INT8
- INTEGER
- INTERSECT
- INTERVAL
- INTO
- IS
- ITERATE
- JOIN
- KEY
- KEYS
- KILL
- LABEL
- LEADING
- LEAVE
- LEFT
- LEVEL
- LIKE
- LIMIT
- LINES
- LOAD
- LOCALTIME
- LOCALTIMESTAMP
- LOCK
- LONG
- LONGBLOB
- LONGTEXT
- LOOP
- LOW_PRIORITY
- MATCH
- MAX
- MAXEXTENTS
- MEDIUMBLOB
- MEDIUMINT
- MEDIUMTEXT
- MIDDLEINT
- MIN
- MINUS
- MINUTE_MICROSECOND
- MINUTE_SECOND
- MOD
- MODE
- MODIFIES
- MODIFY
- NATURAL
- NOAUDIT
- NOCOMPRESS
- NOT
- NOTFOUND
- NOWAIT
- NO_WRITE_TO_BINLOG
- NULL
- NUMBER
- NUMERIC
- OF
- OFFLINE
- ON OPTIMIZE
- ON
- ONLINE
- OPTION
- OPTIONALLY
- OR
- ORDER
- OUT
- OUTER
- OUTFILE
- PCTFREE
- PRECISION
- PRIMARY
- PRIOR
- PRIVILEGES
- PROCEDURE
- PUBLIC
- PURGE
- RAW
- READ
- READS
- REAL
- REFERENCES
- REGEXP
- RELEASE
- RENAME
- REPEAT
- REPLACE
- REQUIRE
- RESOURCE
- RESOLUTION
- RESTRICT
- RETURN
- REVOKE
- RIGHT
- RLIKE
- ROW
- ROWID
- ROWLABEL
- ROWNUM
- ROWS
- SCHEMA
- SCHEMAS
- SECOND_MICROSECOND
- SELECT
- SENSITIVE
- SEPARATOR
- SEQUENCE
- SESSION
- SET
- SHARE
- SHOW
- SIZE
- SMALLINT
- SONAME
- SPATIAL
- SPECIFIC
- SQL
- SQLBUF
- SQLEXCEPTION
- SQLSTATE
- SQLWARNING
- SQL_BIG_RESULT
- SQL_CALC_FOUND_ROWS
- SQL_SMALL_RESULT
- SSL
- START
- STARTING
- STRAIGHT_JOIN
- SUCCESSFUL
- SYNONYM
- SYSDATE
- TABLE
- TABLES
- TERMINATED
- THEN
- TINYBLOB
- TINYINT
- TINYTEXT
- TO
- TRAILING
- TRIGGER
- TRUE
- UID
- UNDO
- UNION
- UNIQUE
- UNLOCK
- UNSIGNED
- UPDATE
- UPGRADE
- USAGE
- USE
- USER
- USING
- UTC_DATE
- UTC_TIME
- UTC_TIMESTAMP
- VALIDATE
- VALUES
- VARBINARY
- VARCHAR
- VARCHAR2
- VARCHARACTER
- VARYING
- VIEW
- WHENEVER
- WHERE
- WITH
Limitations
You can't use the following SQL operators in column naming:
SQL Arithmetic Operators
Operator | Description |
---|---|
+ | Add |
- | Subtract |
* | Multiply |
/ | Divide |
% | Modulo |
SQL Bitwise Operators
Operator | Description |
---|---|
& | Bitwise AND |
| | Bitwise OR |
^ | Bitwise exclusive OR |
SQL Comparison Operators
Operator | Description |
---|---|
= | Equal to |
> | Greater than |
< | Less than |
>= | Greater than or equal to |
<= | Less than or equal to |
<> | Not equal to |
SQL Compound Operators
Operator | Description |
---|---|
+= | Add equals |
-= | Subtract equals |
*= | Multiply equals |
/= | Divide equals |
%= | Modulo equals |
&= | Bitwise AND equals |
^-= | Bitwise exclusive equals |
|*= | Bitwise OR equals |