BlueAroma

down voteacceptedNot sure, but I'll take a shot. When you use #{key}, MyBatis puts extra '' around it if it is a String, Date etc. If you give your column names with a variable you need to use direct Stringreplacement which is ${key}.The error log says something like ...right syntax to use near ''name') VALUES ('some value'...Can you try INSERT INTO t ${key} VALUES #{value} 참고 : https://stackove..

Sample_SQL.xml SELECT *,(6371*acos(cos(radians(#{latitude}))*cos(radians(latitude))*cos(radians(longitude)-radians(#{longitude}))+sin(radians(#{latitude}))*sin(radians(latitude))))AS distance FROM TABLE_NAME HAVINGdistance 특정 위경도에서 반경 2km 내의 데이터 추출