잠

테이블 복사

· 2009-05-05 (화) 03:31:39 · 3508

create table 새로생성할테이블명 (select * from 복사할테이블명);

위와 같은 쿼리문을 실행하면 테이블이 복사됩니다.
(데이터를 삭제하기전 잠시동안 백업용도로 사용하실 수 있습니다.)

가끔 테스트 용으로 쓸만하더라고요^^;;
다만 복사된 테이블에서는 키에 대한 정의가 제외됩니다.

즐거운 코딩되세요~
[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,187건
+
제목 글쓴이 날짜 조회
09-07-11 조회 3,254
09-06-29 조회 3,626
09-06-26 조회 5,247
09-06-25 조회 4,180
09-06-25 조회 2,855
09-06-18 조회 5,411
09-06-17 조회 2,750
09-06-15 조회 2,977
09-06-15 조회 2,607
09-06-15 조회 3,141
09-06-15 조회 3,027
09-06-15 조회 3,044
09-06-15 조회 2,907
09-06-09 조회 3,588
09-05-29 조회 3,206
09-05-29 조회 3,342
09-05-28 조회 3,637
09-05-22 조회 3,023
09-05-16 조회 3,868
09-05-14 조회 3,607
09-05-11 조회 5,966
09-05-08 조회 2,720
09-05-06 조회 2,422
09-05-05 조회 3,509
09-05-04 조회 3,350
09-05-01 조회 2,930
09-04-30 조회 3,486
09-04-30 조회 3,846
09-04-18 조회 2,767
09-04-17 조회 3,158
09-04-13 조회 3,359
09-04-13 조회 2,446
09-04-13 조회 3,157
09-04-13 조회 2,761
09-04-10 조회 3,283
09-04-10 조회 2,710
09-04-07 조회 3,718
09-04-04 조회 3,349
09-04-02 조회 7,316
09-03-19 조회 3,305
09-03-15 조회 5,165
09-03-15 조회 2,794
09-03-13 조회 3,096
09-03-10 조회 3,445
09-03-05 조회 3,991
09-03-05 조회 3,720
09-02-27 조회 4,255
09-02-23 조회 4,517
09-02-23 조회 4,495
09-02-21 조회 3,248
09-02-21 조회 2,861
09-02-17 조회 2,827
09-02-17 조회 3,218
09-02-17 조회 2,601
09-02-17 조회 3,386
09-02-17 조회 3,118
09-02-13 조회 2,922
09-02-09 조회 2,723
09-02-09 조회 3,575
09-02-09 조회 4,640
09-02-09 조회 3,701
09-02-09 조회 3,199
09-02-09 조회 2,941
09-02-05 조회 3,431
09-02-03 조회 6,188
09-01-30 조회 2,942
09-01-25 조회 3,629
09-01-24 조회 3,729
09-01-23 조회 3,896
09-01-23 조회 3,519
09-01-20 조회 5,901
09-01-20 조회 4,329
09-01-17 조회 4,344
09-01-17 조회 3,005
09-01-15 조회 2,584
09-01-14 조회 5,302
09-01-10 조회 3,119
09-01-09 조회 3,017
09-01-08 조회 3,539
09-01-08 조회 3,303
09-01-06 조회 2,961
09-01-05 조회 5,224
08-12-30 조회 3,117
08-12-30 조회 4,540
08-12-29 조회 4,395
08-12-27 조회 2,387
08-12-27 조회 3,253
08-12-27 조회 2,900
08-12-27 조회 3,182
08-12-20 조회 3,950
08-12-20 조회 4,332
08-12-13 조회 4,572
08-12-12 조회 4,646
08-12-12 조회 2,752
08-12-11 조회 2,756
08-12-10 조회 3,573
08-12-06 조회 3,316
08-11-30 조회 3,651
08-11-27 조회 4,200
08-11-26 조회 4,617