솔직히 DB자체를 다루지는 못해요.
하이디 SQL 가지고 다음 정보를 보내드리면 될까요?
/* 구분자를 ";" 으(로) 변경 */
/* 10.52.60.250 에 MariaDB or MySQL (TCP/IP) 을(를) 통해 연결 중, 사용자 이름 "gba", 암호 사용: Yes… */
SELECT CONNECTION_ID();
/* 문자 집합: utf8mb4 */
SHOW /*!50002 GLOBAL */ STATUS;
SELECT NOW();
SHOW VARIABLES;
/* 연결됨. 스레드-ID: 457 */
SHOW TABLES FROM `information_schema`;
SHOW DATABASES;
SHOW OPEN TABLES FROM gb5 WHERE `in_use`!=0;
USE `gb5`;
/* "NAS" 세션 시작 */
SELECT `DEFAULT_COLLATION_NAME` FROM `information_schema`.`SCHEMATA` WHERE `SCHEMA_NAME`='gb5';
SHOW TABLE STATUS FROM `gb5`;
SHOW FUNCTION STATUS WHERE `Db`='gb5';
SHOW PROCEDURE STATUS WHERE `Db`='gb5';
SHOW TRIGGERS FROM `gb5`;
SELECT *, EVENT_SCHEMA AS `Db`, EVENT_NAME AS `Name` FROM information_schema.`EVENTS` WHERE `EVENT_SCHEMA`='gb5';
SELECT * FROM `information_schema`.`COLUMNS` WHERE TABLE_SCHEMA='gb5' AND TABLE_NAME='g5_write_netjiwon' ORDER BY ORDINAL_POSITION;
SHOW INDEXES FROM `g5_write_netjiwon` FROM `gb5`;
SELECT * FROM information_schema.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='gb5' AND TABLE_NAME='g5_write_netjiwon' AND REFERENCED_TABLE_NAME IS NOT NULL;
SELECT * FROM information_schema.KEY_COLUMN_USAGE WHERE TABLE_SCHEMA='gb5' AND TABLE_NAME='g5_write_netjiwon' AND REFERENCED_TABLE_NAME IS NOT NULL;
SHOW ENGINES;
SHOW COLLATION;
SHOW CREATE TABLE `gb5`.`g5_write_netjiwon`;
SELECT CONSTRAINT_NAME, CHECK_CLAUSE FROM `information_schema`.`CHECK_CONSTRAINTS` WHERE CONSTRAINT_SCHEMA='gb5' AND TABLE_NAME='g5_write_netjiwon';
SELECT `wr_id`, `wr_num`, `wr_reply`, `wr_parent`, `wr_is_comment`, `wr_comment`, `wr_comment_reply`, `ca_name`, `wr_option`, `wr_subject`, LEFT(`wr_content`, 256), `wr_seo_title`, LEFT(`wr_link1`, 256), LEFT(`wr_link2`, 256), `wr_link1_hit`, `wr_link2_hit`, `wr_hit`, `wr_good`, `wr_nogood`, `mb_id`, `wr_password`, `wr_name`, `wr_email`, `wr_homepage`, `wr_datetime`, `wr_file`, `wr_last`, `wr_ip`, `wr_facebook_user`, `wr_twitter_user`, `wr_1`, `wr_2`, `wr_3`, `wr_4`, `wr_5`, `wr_6`, `wr_7`, `wr_8`, `wr_9`, `wr_10`, `as_type`, `as_img`, `as_extend`, `as_down`, `as_view`, `as_star_score`, `as_star_cnt`, `as_choice`, `as_choice_cnt`, `as_tag`, `as_thumb` FROM `gb5`.`g5_write_netjiwon` ORDER BY `wr_option` ASC, `ca_name` ASC LIMIT 1000;
SELECT `wr_id`, `wr_num`, `wr_reply`, `wr_parent`, `wr_is_comment`, `wr_comment`, `wr_comment_reply`, `ca_name`, `wr_option`, `wr_subject`, LEFT(`wr_content`, 256), `wr_seo_title`, LEFT(`wr_link1`, 256), LEFT(`wr_link2`, 256), `wr_link1_hit`, `wr_link2_hit`, `wr_hit`, `wr_good`, `wr_nogood`, `mb_id`, `wr_password`, `wr_name`, `wr_email`, `wr_homepage`, `wr_datetime`, `wr_file`, `wr_last`, `wr_ip`, `wr_facebook_user`, `wr_twitter_user`, `wr_1`, `wr_2`, `wr_3`, `wr_4`, `wr_5`, `wr_6`, `wr_7`, `wr_8`, `wr_9`, `wr_10`, `as_type`, `as_img`, `as_extend`, `as_down`, `as_view`, `as_star_score`, `as_star_cnt`, `as_choice`, `as_choice_cnt`, `as_tag`, `as_thumb` FROM `gb5`.`g5_write_netjiwon` ORDER BY `wr_option` ASC, `ca_name` DESC LIMIT 1000;