아래한글로 작성된 대량의글을 DB에 집어넣으려고 합니다~

작성일

메모내용

키워드

08.05.26	사랑은 이유를 묻지 않고 아낌없이 주고도 혹시 모자라자 않나 걱정하는 것입니다.(출처: ‘좋은생각’)	5
08.05.26	이등병은 눈물을 버리고 일병은 자존심을 버리고 상병은 여자를 버리고 병장은 버린 세가지를 되찾아라.(출처: ???)	5
08.05.26	산은 우정이고 하늘은 사랑이다. 산을 바라보면 자연스레 하늘이 보이지만, 무작정 하늘을 바라보면 산은 보이지 않는다.(출처: ‘좋은생각’)	5
08.05.26	형제는 제물보다도 귀한 것이다. 제물은 내가 지켜야 하지만 형제는 나를 지켜준다.(출처: ???)	5
08.05.27	길이 있는 곳으로 가지마라. 길이 없는 곳으로 가서 발자취를 남겨라.(출처: ???)	5
08.05.27	기러기 4만 km 여정. 리더 기러기가 ㅅ 모양의 꼭지점인 선두에 서서 날면, 나머지 기러기들이 75%정도 날기 쉽다고 한다. 무리에서 부득이하게 이탈되는 기러기가 있으면 두마리의 기러기가 함께 이탈하고 다시 날 수 있을때 함께 다시 무리에 합류한다고한다.(출처: ???)	5
08.05.27	잡초만 제거할 수 있는 방법?	5
08.09.28	남에게 하는 거짓말. 그 순간은 넘길 수 있다. 하지만 3자가 보는 입장에서는 그 모습이 과연 좋게만 보일까. 솔찍한 모습으로 생활하자. 나의 생활신조로 삼으며..	1

---------------------------------------------------------------

위와 같이 작성된 글 3천개 정도를 DB에 넣으려고 하는데여.

일일이 글 등록하자니 번거러워서 한번에 넣어보고자 합니다.

그누보드에서 글 하나를 작성해서 DB를 확인해보니

http://127.0.0.1/myadmin/tbl_row_action.php" name="rowsDeleteForm" id="rowsDeleteForm" style="padding: 0px; margin: 0px; display: inline; font-family: sans-serif; line-height: normal;">

			http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_id%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_id	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_num%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_num	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_reply%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_reply	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_parent%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_parent	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_is_comment%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_is_comment	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_comment%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_comment	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_comment_reply%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_comment_reply	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60ca_name%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">ca_name	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_option%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_option	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_subject%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_subject	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_content%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_content	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_link1%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_link1	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_link2%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_link2	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_link1_hit%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_link1_hit	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_link2_hit%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_link2_hit	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_hit%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_hit	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_good%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_good	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_nogood%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_nogood	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60mb_id%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">mb_id	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_password%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_password	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_name%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_name	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_email%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_email	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_homepage%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_homepage	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_datetime%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_datetime	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_file%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_file	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_last%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_last	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_ip%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_ip	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_facebook_user%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_facebook_user	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_twitter_user%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_twitter_user	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_1%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_1	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_2%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_2	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_3%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_3	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_4%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_4	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_5%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_5	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_6%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_6	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_7%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_7	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_8%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_8	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_9%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_9	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60+ORDER+BY+%60g5_write_test1%60.%60wr_10%60+ASC&token=84cb49649ad7c0731f77ebd362aa30bd" title="정렬" style="text-decoration: none; color: rgb(0, 0, 255);">wr_10
	http://127.0.0.1/myadmin/tbl_change.php?db=note&table=g5_write_test1&primary_key=%60g5_write_test1%60.%60wr_id%60+%3D+1&sql_query=SELECT+%2A+FROM+%60g5_write_test1%60&goto=sql.php&token=84cb49649ad7c0731f77ebd362aa30bd" style="text-decoration: none; color: rgb(0, 0, 255);">http://127.0.0.1/myadmin/themes/original/img/b_edit.png" title="수정" alt="수정" class="icon" style="height:16px; width:16px; vertical-align: middle; border: 0px; margin: 0px;">	http://127.0.0.1/myadmin/sql.php?db=note&table=g5_write_test1&sql_query=DELETE+FROM+%60note%60.%60g5_write_test1%60+WHERE+%60g5_write_test1%60.%60wr_id%60+%3D+1+LIMIT+1&zero_rows=%EC%84%A0%ED%83%9D%ED%95%9C+%EC%A4%84%28%EB%A0%88%EC%BD%94%EB%93%9C%29%EC%9D%84+%EC%82%AD%EC%A0%9C+%ED%95%98%EC%98%80%EC%8A%B5%EB%8B%88%EB%8B%A4.&goto=sql.php%3Fdb%3Dnote%26table%3Dg5_write_test1%26sql_query%3DSELECT%2B%252A%2BFROM%2B%2560g5_write_test1%2560%26zero_rows%3D%25EC%2584%25A0%25ED%2583%259D%25ED%2595%259C%2B%25EC%25A4%2584%2528%25EB%25A0%2588%25EC%25BD%2594%25EB%2593%259C%2529%25EC%259D%2584%2B%25EC%2582%25AD%25EC%25A0%259C%2B%25ED%2595%2598%25EC%2598%2580%25EC%258A%25B5%25EB%258B%2588%25EB%258B%25A4.%26goto%3Dtbl_structure.php%26token%3D84cb49649ad7c0731f77ebd362aa30bd&token=84cb49649ad7c0731f77ebd362aa30bd" style="text-decoration: none; color: rgb(0, 0, 255);">http://127.0.0.1/myadmin/themes/original/img/b_drop.png" title="삭제" alt="삭제" class="icon" style="height:16px; width:16px; vertical-align: middle; border: 0px; margin: 0px;">	1	-1		1	0	0			html1	수행 해야할 일	*****현재 수행 위치*** 1. 메모...**			0	0	1	0	0	admin	*263B07734A044F56EE6417407BFC01F2D0A1D9A5	최고관리자	admin@domain.com		2014-07-23 14:15:52	0	2014-07-23 14:16:15	127.0.0.1

이와 같이 글이 들어가더라구여.

wr_datetime에 "작성일"를,

wr_content에 "메모 내용"을,

wr_subject에 "키워드"를,

넣고자 합니다. (이외 나머지 값들은 통일해서)

DB에서 살펴보니 임포트 할 수 있는 방법이 csv나 sql로 작성해서 넣는 방법으로 해결해야하는것 같던데,

혹시 이런 비슷한 경험 있으신분 계신가요~?

있으시다면 조언 좀 부탁드리겠습니다 ^^;

(죄송합니다 글 등록해 보니 DB 테이블 부분이 표 크기가 꺠지네여; 이해 부탁드립니다 !)

아래한글로 작성된 대량의글을 DB에 집어넣으려고 합니다~ 채택완료

답변 1개

답변에 대한 댓글 1개

아래한글로 작성된 대량의글을 DB에 집어넣으려고 합니다~ 채택완료

답변 1개

답변에 대한 댓글 1개

공유하기