[Spring/JUnit] H2 ์˜ˆ์•ฝ์–ด user ๋•Œ๋ฌธ์— ๋ฐœ์ƒ : Error executing DDL "drop table if exists user cascade " via JDBC [Syntax error in SQL statement "drop table if exists [*]user cascade "; expected "identifier";]
ยท
Backend/Spring Boot
โ—๏ธ์—๋Ÿฌ ๋ฉ”์‹œ์ง€Error executing DDL "drop table if exists user cascade " via JDBC [Syntax error in SQL statement "drop table if exists [*]user cascade "; expected "identifier";]     ๐Ÿ’ป ๊ฐœ๋ฐœ ํ™˜๊ฒฝFramework : Spring Boot`3.2.3`DB : MySQL(๋กœ์ปฌ), H2(ํ…Œ์ŠคํŠธ)Library : JPA, QueryDSL`5.0.0`Test : JUnit     ๐Ÿ”Ž ์›์ธSpring์—์„œ JPA Repository ํ…Œ์ŠคํŠธ๋ฅผ ์ง„ํ–‰ํ•˜๋Š”๋ฐ ์—๋Ÿฌ๊ฐ€ ๋‚ฌ๋‹ค.DB๋Š” ๋กœ์ปฌ์—์„œ ๊ฐœ๋ฐœ์„ ์œ„ํ•ด MySQL์„ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ์ง€๋งŒ, ํ…Œ์ŠคํŠธ๋ฅผ ์œ„ํ•ด์„œ ๋‚ด์žฅํ˜• ์ธ๋ฉ”๋ชจ๋ฆฌ DB์ธ H2๋ฅผ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ์—ˆ๋‹ค. ..
[Spring/MySQL] SQL Error: 1064, SQLState: 42000 - MySQL ์˜ˆ์•ฝ์–ด ์‚ฌ์šฉํ•ด์„œ ๋‚˜๋Š” ์—๋Ÿฌ
ยท
Backend/Spring Boot
๐Ÿ’ป ์—๋Ÿฌ ๋ฉ”์‹œ์ง€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 'match (distance, match_date, max_start_time, min_start_time, place_id) values ' at line 1     ๐Ÿ” ์›์ธํ…Œ์ด๋ธ”๋ช…์ธ match ๊ฐ€ MySQL ์˜ˆ์•ฝ์–ด์—ฌ์„œ ๋‚ฌ๋‹ค. MySQL ์˜ˆ์•ฝ์–ด ๋ชฉ๋ก์„ ๊ฒ€์ƒ‰ํ•ด์„œ ์ฐพ์€ ๊ฒฐ๊ณผ MATCH ๊ฐ€ ์žˆ๋Š” ๊ฒƒ์„ ํ™•์ธํ•  ์ˆ˜ ์žˆ์—ˆ๋‹ค. https://zetawiki.com/wiki/MySQL_%EC%98%88%EC%95%BD%EC%96%B4 MySQL ์˜ˆ์•ฝ์–ด - ์ œํƒ€์œ„..
giraffe_
'์˜ˆ์•ฝ์–ด' ํƒœ๊ทธ์˜ ๊ธ€ ๋ชฉ๋ก