MYSQL 테이블 생성 안되는 에러 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near option

MYSQL 테이블 생성 안되는 에러 : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘option

자꾸 JPA로 토이프로젝트 엔티티 만드는데 문제가 없는데도 에러가 나서 삽질을 조금 했다.

[2022-07-11 11:17:05] [42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'option (id bigint not null auto_increment, is_answer bit, value varchar(255), qu' at line 1

— | — | — 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 CURRENTDATE | CURRENTTIME | CURRENTTIMESTAMP CURRENTUSER | CURSOR | DATABASE DATABASES | DAYHOUR | DAYMICROSECOND DAYMINUTE | DAYSECOND | 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 | HIGHPRIORITY HOURMICROSECOND | HOURMINUTE | HOURSECOND 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 | LINES LOAD | LOCALTIME | LOCALTIMESTAMP LOCK | LONG | LONGBLOB LONGTEXT | LOOP | LOWPRIORITY MATCH | MEDIUMBLOB | MEDIUMINT MEDIUMTEXT | MIDDLEINT | MINUTEMICROSECOND MINUTESECOND | MOD | MODIFIES NATURAL | NOT | NOWRITETOBINLOG NULL | NUMERIC | ON OPTIMIZE | OPTION | OPTIONALLY OR | ORDER | OUT OUTER | OUTFILE | PRECISION PRIMARY | PROCEDURE | PURGE READ | READS | REAL REFERENCES | REGEXP | RELEASE RENAME | REPEAT | REPLACE REQUIRE | RESTRICT | RETURN REVOKE | RIGHT | RLIKE SCHEMA | SCHEMAS | SECONDMICROSECOND SELECT | SENSITIVE | SEPARATOR SET | SHOW | SMALLINT SONAME | SPATIAL | SPECIFIC SQL | SQLEXCEPTION | SQLSTATE SQLWARNING | SQLBIGRESULT | SQLCALCFOUNDROWS SQLSMALLRESULT | SSL | STARTING STRAIGHTJOIN | TABLE | TERMINATED THEN | TINYBLOB | TINYINT TINYTEXT | TO | TRAILING TRIGGER | TRUE | UNDO UNION | UNIQUE | UNLOCK UNSIGNED | UPDATE | USAGE USE | USING | UTCDATE UTCTIME | UTCTIMESTAMP | VALUES VARBINARY | VARCHAR | VARCHARACTER VARYING | WHEN | WHERE WHILE | WITH | WRITE XOR | YEAR_MONTH | ZEROFILL

끝!

• Jmeter를 이번 프로젝트에 적용하게끔 도와준 초루님 감사합니다.