[SQL Error] 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 ' order
Order Entity를 만들어서 @Entity 어노테이션 달고 실행 했더니 에러가 떴다. 이는 order 라는 테이블 명을 사용할 수 없다는 에러이다. order 라는 테이블 명은 sql 예약어 이기 때문에 사용할 수 없다. 따라서 @Table(name = "orders") 라는 어노테이션으로 테이블 명을 order에서 orders로 바꿔주어 에러를 해결했다.
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 |
