다른 my-sql 테이블에서 데이타 이전하기 > MySQL Tip

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