Kata yang harus dihindari dalam database mysql
Anda pernah dengar kata Reserved
Words, kata tersebut adalah sebutan untuk kumpulan perintah dasar yang
digunakan oleh bahasa pemrograman maupun sistem database. Kata yang termasuk
dalam kategori tersebut tidak boleh kita gunakan dalam penamaan variabel, nama
field, nama tabel data, maupun nama database. Kata apa saja yang tidak bisa
kita gunakan dalam database mysql?
Berikut ini daftar kata/printah
dalam mysql database yang tidak boleh kita gunakan untuk penamaan variabel,
tabel, field maupun database.
|
ADD
|
ALL
|
ALTER
|
|
ANALYZE
|
AND
|
AS
|
|
ASC
|
ASENSITIVE
|
AUTO_INCREMENT
|
|
BDB
|
BEFORE
|
BERKELEYDB
|
|
BETWEEN
|
BIGINT
|
BINARY
|
|
BLOB
|
BOTH
|
BY
|
|
CALL
|
CASCADE
|
CASE
|
|
CHANGE
|
CHAR
|
CHARACTER
|
|
CHECK
|
COLLATE
|
COLUMN
|
|
COLUMNS
|
CONDITION
|
CONNECTION
|
|
CONSTRAINT
|
CONTINUE
|
CREATE
|
|
CROSS
|
CURRENT_DATE
|
CURRENT_TIME
|
|
CURRENT_TIMESTAMP
|
CURSOR
|
DATABASE
|
|
DATABASES
|
DAY_HOUR
|
DAY_MICROSECOND
|
|
DAY_MINUTE
|
DAY_SECOND
|
DEC
|
|
DECIMAL
|
DECLARE
|
DEFAULT
|
|
DELAYED
|
DELETE
|
DESC
|
|
DESCRIBE
|
DETERMINISTIC
|
DISTINCT
|
|
DISTINCTROW
|
DIV
|
DOUBLE
|
|
DROP
|
ELSE
|
ELSEIF
|
|
ENCLOSED
|
ESCAPED
|
EXISTS
|
|
EXIT
|
EXPLAIN
|
FALSE
|
|
FETCH
|
FIELDS
|
FLOAT
|
|
FOR
|
FORCE
|
FOREIGN
|
|
FOUND
|
FRAC_SECOND
|
FROM
|
|
FULLTEXT
|
GRANT
|
GROUP
|
|
HAVING
|
HIGH_PRIORITY
|
HOUR_MICROSECOND
|
|
HOUR_MINUTE
|
HOUR_SECOND
|
IF
|
|
IGNORE
|
IN
|
INDEX
|
|
INFILE
|
INNER
|
INNODB
|
|
INOUT
|
INSENSITIVE
|
INSERT
|
|
INT
|
INTEGER
|
INTERVAL
|
|
INTO
|
IO_THREAD
|
IS
|
|
ITERATE
|
JOIN
|
KEY
|
|
KEYS
|
KILL
|
LEADING
|
|
LEAVE
|
LEFT
|
LIKE
|
|
LIMIT
|
LINES
|
LOAD
|
|
LOCALTIME
|
LOCALTIMESTAMP
|
LOCK
|
|
LONG
|
LONGBLOB
|
LONGTEXT
|
|
LOOP
|
LOW_PRIORITY
|
MASTER_SERVER_ID
|
|
MATCH
|
MEDIUMBLOB
|
MEDIUMINT
|
|
MEDIUMTEXT
|
MIDDLEINT
|
MINUTE_MICROSECOND
|
|
MINUTE_SECOND
|
MOD
|
NATURAL
|
|
NOT
|
NO_WRITE_TO_BINLOG
|
NULL
|
|
NUMERIC
|
ON
|
OPTIMIZE
|
|
OPTION
|
OPTIONALLY
|
OR
|
|
ORDER
|
OUT
|
OUTER
|
|
OUTFILE
|
PRECISION
|
PRIMARY
|
|
PRIVILEGES
|
PROCEDURE
|
PURGE
|
|
READ
|
REAL
|
REFERENCES
|
|
REGEXP
|
RENAME
|
REPEAT
|
|
REPLACE
|
REQUIRE
|
RESTRICT
|
|
RETURN
|
REVOKE
|
RIGHT
|
|
RLIKE
|
SECOND_MICROSECOND
|
SELECT
|
|
SENSITIVE
|
SEPARATOR
|
SET
|
|
SHOW
|
SMALLINT
|
SOME
|
|
SONAME
|
SPATIAL
|
SPECIFIC
|
|
SQL
|
SQLEXCEPTION
|
SQLSTATE
|
|
SQLWARNING
|
SQL_BIG_RESULT
|
SQL_CALC_FOUND_ROWS
|
|
SQL_SMALL_RESULT
|
SQL_TSI_DAY
|
SQL_TSI_FRAC_SECOND
|
|
SQL_TSI_HOUR
|
SQL_TSI_MINUTE
|
SQL_TSI_MONTH
|
|
SQL_TSI_QUARTER
|
SQL_TSI_SECOND
|
SQL_TSI_WEEK
|
|
SQL_TSI_YEAR
|
SSL
|
STARTING
|
|
STRAIGHT_JOIN
|
STRIPED
|
TABLE
|
|
TABLES
|
TERMINATED
|
THEN
|
|
TIMESTAMPADD
|
TIMESTAMPDIFF
|
TINYBLOB
|
|
TINYINT
|
TINYTEXT
|
TO
|
|
TRAILING
|
TRUE
|
UNDO
|
|
UNION
|
UNIQUE
|
UNLOCK
|
|
UNSIGNED
|
UPDATE
|
USAGE
|
|
USE
|
USER_RESOURCES
|
USING
|
|
UTC_DATE
|
UTC_TIME
|
UTC_TIMESTAMP
|
|
VALUES
|
VARBINARY
|
VARCHAR
|
|
VARCHARACTER
|
VARYING
|
WHEN
|
|
WHERE
|
WHILE
|
WITH
|
|
WRITE
|
XOR
|
YEAR_MONTH
|
|
ZEROFILL
|
|
|
0 komentar:
Posting Komentar