"TEST DB ACCESS"의 두 판 사이의 차이

10번째 줄: 10번째 줄:
 
  db=ID
 
  db=ID
 
  |from=MAIN_INFORMATION
 
  |from=MAIN_INFORMATION
  |where='{{{키|}}}'=ITEM_KOR_NAME
+
  |where=P4-AR 소총=ITEM_KOR_NAME
 
  |data=ITEM_KOR_NAME=ITEM_KOR_NAME, ITEM_NAME = ITEM_NAME, ITEM_JSON_CLASS = ITEM_JSON_CLASS, ITEM_JSON_CLASS_ITEMNAME = ITEM_JSON_CLASS_ITEMNAME, ITEM_INI_CLASS = ITEM_INI_CLASS, ITEM_SHOP_CLASS = ITEM_SHOP_CLASS, ITEM_DESC = ITEM_DESC,ITEM_REF
 
  |data=ITEM_KOR_NAME=ITEM_KOR_NAME, ITEM_NAME = ITEM_NAME, ITEM_JSON_CLASS = ITEM_JSON_CLASS, ITEM_JSON_CLASS_ITEMNAME = ITEM_JSON_CLASS_ITEMNAME, ITEM_INI_CLASS = ITEM_INI_CLASS, ITEM_SHOP_CLASS = ITEM_SHOP_CLASS, ITEM_DESC = ITEM_DESC,ITEM_REF
 
}}
 
}}
 +
{{#external_value:ITEM_NAME}}

2023년 1월 25일 (수) 12:24 판



SELECT item_kor_name,item_name,item_json_class,item_json_class_itemname,item_ini_class,item_shop_class,item_desc,item_ref FROM `MAIN_INFORMATION` WHERE P4-AR 소총=ITEM_KOR_NAME 쿼리는 유효하지 않습니다. (Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '\xEC\x86\x8C\xEC\xB4\x9D=ITEM_KOR_NAME' at line 1 (127.0.0.1:3307) Function: EDConnectorRdbms::fetch Query: SELECT item_kor_name,item_name,item_json_class,item_json_class_itemname,item_ini_class,item_shop_class,item_desc,item_ref FROM `MAIN_INFORMATION` WHERE P4-AR 소총=ITEM_KOR_NAME ) 오류: 지역 변수가 설정되어 있지 않습니다.