다른 my-sql 테이블에서 데이타 이전하기
페이지 정보
작성자
human
쪽지보내기
메일보내기
자기소개
아이디로 검색
전체게시물
댓글 0건
조회 10,705회
작성일 07-09-07 19:36
본문
Insert Into cs(컬럼명...)
SELECT distinct
c.ce AS ce
, c.pt as pt
, c.dh as dh
, c.ne as ne
, t.tId as tid
, t.lcd as lCd
FROM cs c, ls t
Where c.lCd = t.lCd
order by c.dh, c.ne
Insert Into kumdong2.g4_write_free2(wr_id,ca_name,wr_homepage,wr_email,wr_subject,wr_datetime,wr_content)
SELECT
morning_bmain_freeboard.board_id AS wr_id
, morning_bmain_freeboard.board_name as ca_name
, morning_bmain_freeboard.board_homepage as wr_homepage
, morning_bmain_freeboard.board_email as wr_email
, morning_bmain_freeboard.board_subject as wr_subject
, morning_bmain_freeboard.register_date as wr_datetime
, morning_bmain_freeboard.board_body as wr_content
FROM kumdong.morning_bmain_freeboard
SELECT distinct
c.ce AS ce
, c.pt as pt
, c.dh as dh
, c.ne as ne
, t.tId as tid
, t.lcd as lCd
FROM cs c, ls t
Where c.lCd = t.lCd
order by c.dh, c.ne
Insert Into kumdong2.g4_write_free2(wr_id,ca_name,wr_homepage,wr_email,wr_subject,wr_datetime,wr_content)
SELECT
morning_bmain_freeboard.board_id AS wr_id
, morning_bmain_freeboard.board_name as ca_name
, morning_bmain_freeboard.board_homepage as wr_homepage
, morning_bmain_freeboard.board_email as wr_email
, morning_bmain_freeboard.board_subject as wr_subject
, morning_bmain_freeboard.register_date as wr_datetime
, morning_bmain_freeboard.board_body as wr_content
FROM kumdong.morning_bmain_freeboard
댓글목록
등록된 댓글이 없습니다.