728x90
구글 번역기 :
전형적인 문법 오류 메세지로 구체적으로 해당 에러는 'SCHEMA'는 Mysql에서 예약어에 해당하기 때문에 발생하는 에러이다.
테이블을 생성할 때 예약어를 컬럼명이나 DB명으로 사용은 가능하나 사용하지 않는 것이 낫다.
※ 예약어를 컬럼명으로 사용한 경우
-
키보드 TAB 위에 ` ← 이 키를 사용하면 해결된다.
-
ex ) INSERT INTO TABLE_A ( `SCHEMA` ) VALUES( NULL ) → 올바른 예
-
ex ) INSERT INTO TABLE_A ( SCHEMA ) VALUES( NULL ) → 바르지 못한 예
Mysql 예약어 종류
|
ACCESSIBLE
|
ADD
|
ALL
|
|
ALTER
|
ANALYZE
|
AND
|
|
AS
|
ASC
|
ASENSITIVE
|
|
BEFORE
|
BETWEEN
|
BIGINT
|
|
BINARY
|
BLOB
|
BOTH
|
|
BY
|
CALL
|
CASCADE
|
|
CASE
|
CHANGE
|
CHAR
|
|
CHARACTER
|
CHECK
|
COLLATE
|
|
COLUMN
|
CONDITION
|
CONSTRAINT
|
|
CONTINUE
|
CONVERT
|
CREATE
|
|
CROSS
|
CURRENT_DATE
|
CURRENT_TIME
|
|
CURRENT_TIMESTAMP
|
CURRENT_USER
|
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
|
DUAL
|
|
EACH
|
ELSE
|
ELSEIF
|
|
ENCLOSED
|
ESCAPED
|
EXISTS
|
|
EXIT
|
EXPLAIN
|
FALSE
|
|
FETCH
|
FLOAT
|
FLOAT4
|
|
FLOAT8
|
FOR
|
FORCE
|
|
FOREIGN
|
FROM
|
FULLTEXT
|
|
GRANT
|
GROUP
|
HAVING
|
|
HIGH_PRIORITY
|
HOUR_MICROSECOND
|
HOUR_MINUTE
|
|
HOUR_SECOND
|
IF
|
IGNORE
|
|
IN
|
INDEX
|
INFILE
|
|
INNER
|
INOUT
|
INSENSITIVE
|
|
INSERT
|
INT
|
INT1
|
|
INT2
|
INT3
|
INT4
|
|
INT8
|
INTEGER
|
INTERVAL
|
|
INTO
|
IS
|
ITERATE
|
|
JOIN
|
KEY
|
KEYS
|
|
KILL
|
LEADING
|
LEAVE
|
|
LEFT
|
LIKE
|
LIMIT
|
|
LINEAR
|
LINES
|
LOAD
|
|
LOCALTIME
|
LOCALTIMESTAMP
|
LOCK
|
|
LONG
|
LONGBLOB
|
LONGTEXT
|
|
LOOP
|
LOW_PRIORITY
|
MASTER_SSL_VERIFY_SERVER_CERT
|
|
MATCH
|
MAXVALUE
|
MEDIUMBLOB
|
|
MEDIUMINT
|
MEDIUMTEXT
|
MIDDLEINT
|
|
MINUTE_MICROSECOND
|
MINUTE_SECOND
|
MOD
|
|
MODIFIES
|
NATURAL
|
NOT
|
|
NO_WRITE_TO_BINLOG
|
NULL
|
NUMERIC
|
|
ON
|
OPTIMIZE
|
OPTION
|
|
OPTIONALLY
|
OR
|
ORDER
|
|
OUT
|
OUTER
|
OUTFILE
|
|
PRECISION
|
PRIMARY
|
PROCEDURE
|
|
PURGE
|
RANGE
|
READ
|
|
READS
|
READ_WRITE
|
REAL
|
|
REFERENCES
|
REGEXP
|
RELEASE
|
|
RENAME
|
REPEAT
|
REPLACE
|
|
REQUIRE
|
RESIGNAL
|
RESTRICT
|
|
RETURN
|
REVOKE
|
RIGHT
|
|
RLIKE
|
SCHEMA
|
SCHEMAS
|
|
SECOND_MICROSECOND
|
SELECT
|
SENSITIVE
|
|
SEPARATOR
|
SET
|
SHOW
|
|
SIGNAL
|
SMALLINT
|
SPATIAL
|
|
SPECIFIC
|
SQL
|
SQLEXCEPTION
|
|
SQLSTATE
|
SQLWARNING
|
SQL_BIG_RESULT
|
|
SQL_CALC_FOUND_ROWS
|
SQL_SMALL_RESULT
|
SSL
|
|
STARTING
|
STRAIGHT_JOIN
|
TABLE
|
|
TERMINATED
|
THEN
|
TINYBLOB
|
|
TINYINT
|
TINYTEXT
|
TO
|
|
TRAILING
|
TRIGGER
|
TRUE
|
|
UNDO
|
UNION
|
UNIQUE
|
|
UNLOCK
|
UNSIGNED
|
UPDATE
|
|
USAGE
|
USE
|
USING
|
|
UTC_DATE
|
UTC_TIME
|
UTC_TIMESTAMP
|
|
VALUES
|
VARBINARY
|
VARCHAR
|
|
VARCHARACTER
|
VARYING
|
WHEN
|
|
WHERE
|
WHILE
|
WITH
|
|
WRITE
|
XOR
|
YEAR_MONTH
|
|
ZEROFILL
|
|
|
728x90