Difference between revisions of "Reserved Words"

From LongJump Support Wiki
imported>Aeric
imported>Aeric
Line 144: Line 144:
FULLTEXT
FULLTEXT
FUNCTION
FUNCTION
GENERAL
GEOMETRY
GEOMETRY
GOTO
GOTO
Line 163: Line 164:
IF
IF
IGNORE
IGNORE
IGNORE_SERVER_IDS
IMPLEMENTS
IMPLEMENTS
IMPORT
IMPORT
Line 217: Line 219:
LOW_PRIORITY
LOW_PRIORITY
LOWER
LOWER
MASTER_HEAERBEAT_PERIOD
MASTER_SERVER_ID
MASTER_SERVER_ID
MASTER_SSL_VERIFY_SERVER_CERT
MASTER_SSL_VERIFY_SERVER_CERT
MATCH
MATCH
MAX
MAX
MAXVALUE
MEDIUMBLOB
MEDIUMBLOB
MEDIUMINT
MEDIUMINT
Line 302: Line 306:
REPLACE
REPLACE
REQUIRE
REQUIRE
RESIGNAL
RESTRICT
RESTRICT
RETURN
RETURN
Line 332: Line 337:
SIGN_HASH_PRODUCT
SIGN_HASH_PRODUCT
SIGN_HASH_PROJECT
SIGN_HASH_PROJECT
SIGNAL
SIGNED_BY_ACCOUNT
SIGNED_BY_ACCOUNT
SIGNED_BY_CASE
SIGNED_BY_CASE
Line 350: Line 356:
SIGNED_BY_PRODUCT
SIGNED_BY_PRODUCT
SIGNED_BY_PROJECT
SIGNED_BY_PROJECT
SLOW
SMALLINT
SMALLINT
SOME
SOME

Revision as of 00:59, 11 November 2011

These words are used within the platform internally, and cannot be used for names.

See also: Reserved Words by Group
A
ABS
ABSTRACT
ACCESSIBLE
ACTIVITIES
ADD
AFFILIATE_ID
ALL
ALTER
ANALYZE
AND
AND
APPOINTMENTS
AS
ASC
ASENSITIVE
ASSERT
AUTO_INCREMENT
BDB
BEFORE
BETWEEN
BIGINT
BINARY
BLOB
BOOLEAN
BOTH
BREAK
BTREE
BY
BYTE
CALL
CAMPAIGNS
CASCADE
CASE
CASES
CATCH
CEIL
CHANGE
CHAR
CHARACTER
CHECK
CLASS
CLASS
COFF
COLLATE
COLUMN
COLUMNS
COMMENTS
CONCAT
CONDITION
CONNECTION
CONST
CONSTRAINT
contact_email
contact_fax
contact_first_name
contact_last_name
contact_mobile_phone
contact_phone
contact_title
CONTACTS
CONTAINS
CONTINUE
CONTRACTS
CONVERT
CREATE
CREATED_ID
CREATOR
CRITERIA
CROSS
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
CURRENT_USER
CURSOR
CUSTOMER_ID
DATABASE
DATABASES
DATE
DATE_CREATED
DATE_MODIFIED
DATEADD
DATECOMP
DATESUB
DATEVALUE
DAY
DAY_HOUR
DAY_MICROSECOND
DAY_MINUTE
DAY_SECOND
DEC
DECIMAL
DECLARE
DEFAULT
DEFAULT
DELAYED
DELETE
DESC
DESCRIBE
DETERMINISTIC
DISTINCT
DISTINCTROW
DIV
DO
DOCUMENTS
DONE
DOUBLE
DOUBLE
DROP
DUAL
EACH
ELSE
ELSE
ELSEIF
EMAIL_ACTIVITIES
ENCLOSED
ENDSWITH
ENUM
ERRORS
ESCAPED
EXISTS
EXIT
EXP
EXPLAIN
EXTENDS
FALSE
FETCH
FIELDS
FINAL
FINALLY
FIND
FIRST_NAME
FLOAT
FLOAT4
FLOAT8
FLOOR
FOR
FORCE
FOREIGN
FROM
FULLTEXT
FUNCTION
GENERAL
GEOMETRY
GOTO
GOTO
GRANT
GROUP
HASH
HAVING
HELP
HIGH_PRIORITY
HISTORY
HOUR
HOUR_MICROSECOND
HOUR_MINUTE
HOUR_SECOND
ID
IF
IF
IGNORE
IGNORE_SERVER_IDS
IMPLEMENTS
IMPORT
IN
INDEX
INFILE
INNER
INNODB
INOUT
INSENSITIVE
INSERT
INSTANCEOF
INT
INT1
INT2
INT3
INT4
INT8
INTEGER
INTERFACE
INTERVAL
INTO
IS
ISCHANGED
ISNEW
ISNULL
ITERATE
JOIN
KEY
KEYS
KILL
LABEL 
LAST_MODIFIED_TIMESTAMP
LAST_NAME
LEADING
LEAVE
LEFT
LEN
LIFECYCLE
LIKE
LIMIT
LINEAR                 
LINES
LN
LOAD
LOCALTIME
LOCALTIMESTAMP
LOCK
LOG
LONG
LONGBLOB
LONGTEXT
LOOP
LOW_PRIORITY
LOWER
MASTER_HEAERBEAT_PERIOD
MASTER_SERVER_ID
MASTER_SSL_VERIFY_SERVER_CERT
MATCH
MAX
MAXVALUE
MEDIUMBLOB
MEDIUMINT
MEDIUMTEXT
MIDDLEINT
MIN
MINUTE
MINUTE_MICROSECOND
MINUTE_SECOND
MOD
MOD
MODIFIED_ID
MODIFIER
MODIFIES
MONTH
MRG_MYISAM
NAME
NATIVE
NATURAL
NEW
NO_WRITE_TO_BINLOG
NOT
NOT
NOW
NULL
NUMERIC
OBJECT_ID
ON
OPPORTUNITIES
OPTIMIZE
OPTION
OPTIONALLY
OR
OR
ORDER
OUT
OUTER
OUTFILE
OWNER
OWNER_ID
OWNER_TEAM_ID
P_KEYWORD
PACKAGE
PLANS
POW
PRECISION
PRICELIST
PRIMARY
PRIOR_NAME
PRIORVALUE
PRIVATE
PRIVILEGES
PROCEDURE
PRODUCTS
PROTECTED
PUBLIC
PURGE
PURPOSE_ACCOUNT
PURPOSE_CASE
PURPOSE_CONTACT
PURPOSE_CONTRACT
PURPOSE_LEAD
PURPOSE_OPPORTUNITY_V2
PURPOSE_PRICE_BOOK
PURPOSE_PRODUCT
PURPOSE_PROJECT
RANGE                 
READ
READ_ONLY       
READ_WRITE
READS
REAL
RECORD
REFERENCES
REGEXP
RELEASE
RENAME
REPEAT
REPLACE
REPLACE
REQUIRE
RESIGNAL
RESTRICT
RETURN
RETURNS
REVOKE
RIGHT
RLIKE
ROUND
RTREE
S
SCHEMA
SCHEMAS
SEARCH_STRING
SECOND
SECOND_MICROSECOND
SELECT
SENSITIVE
SEPARATOR
SET
SHORT
SHOW
SHOW_LAYOUT
SIGN_HASH_ACCOUNT
SIGN_HASH_CASE
SIGN_HASH_CONTACT
SIGN_HASH_CONTRACT
SIGN_HASH_LEAD
SIGN_HASH_OPPORTUNITY_V2
SIGN_HASH_PRICE_BOOK
SIGN_HASH_PRODUCT
SIGN_HASH_PROJECT
SIGNAL
SIGNED_BY_ACCOUNT
SIGNED_BY_CASE
SIGNED_BY_CONTACT
SIGNED_BY_CONTRACT
SIGNED_BY_DATE_ACCOUNT
SIGNED_BY_DATE_CASE
SIGNED_BY_DATE_CONTACT
SIGNED_BY_DATE_CONTRACT
SIGNED_BY_DATE_LEAD
SIGNED_BY_DATE_OPPORTUNITY_V2
SIGNED_BY_DATE_PRICE_BOOK
SIGNED_BY_DATE_PRODUCT
SIGNED_BY_DATE_PROJECT
SIGNED_BY_LEAD
SIGNED_BY_OPPORTUNITY_V2
SIGNED_BY_PRICE_BOOK
SIGNED_BY_PRODUCT
SIGNED_BY_PROJECT
SLOW
SMALLINT
SOME
SONAME
SOURCEPAGE
SPATIAL
SPECIFIC
SPENDING
SQL
SQL_BIG_RESULT
SQL_CALC_FOUND_ROWS
SQL_SMALL_RESULT
SQLEXCEPTION
SQLSTATE
SQLWARNING
SQRT
SSL
STARTING
STARTSWITH
STATIC
STRAIGHT_JOIN
STRICTFP
STRIPED
SUBSTRING
SUPER
SWITCH
SYNCHRONIZED
T
TABLE
TABLES
TAGLIST
TARGETPAGE
TERMINATED
TEXT
THEN
THIS
THROW
THROWS
TIME
TIMEVALUE
TINYBLOB
TINYINT
TINYTEXT
TO
TODAY
TOP_TAB
TRAILING
TRANSIENT
TRIGGER
TRIM
TRUE
TRY
TYPES
UNDO
UNION
UNIQUE
UNLOCK
UNSIGNED
UPDATE
UPGRADE
UPPER
USAGE
USE
USER
USER_RESOURCES
USERID
USERPRIMARYTEAMID
USING
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
VALUE
VALUES
VARBINARY
VARCHAR
VARCHARACTER
VARYING
VOID
VOLATILE
WARNINGS
WEEKDAY
WHEN
WHERE
WHILE
WITH
WORKFLOW_HISTORY
WRITE
XOR
YEAR
YEAR_MONTH
ZEROFILL