엑

insert에서 where 사용하기

· 2008-12-06 (토) 22:30:12 · 3256
insert into  g4_member( mb_name) select 'abc' from dual where 0>1 limit 1;

조건문에 다음을 쓰는 것도 참고하세요.
http://dev.mysql.com/doc/refman/4.1/en/exists-and-not-exists-subqueries.html
[이 게시물은 관리자님에 의해 2011-10-31 17:27:00 MySQL에서 이동 됨]
|
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
11-08-16 조회 2,448
11-08-16 조회 2,429
11-08-12 조회 2,270
11-08-02 조회 2,845
11-07-27 조회 2,227
11-07-25 조회 2,343
11-06-28 조회 2,536
11-06-06 조회 4,050
11-06-04 조회 2,629
11-04-25 조회 6,211
11-04-22 조회 2,711
11-04-21 조회 2,944
11-04-08 조회 3,354
11-03-31 조회 2,864
11-03-20 조회 3,291
11-03-10 조회 2,895
11-03-04 조회 3,212
11-03-03 조회 2,947
11-02-26 조회 4,377
11-02-14 조회 5,726
11-02-08 조회 3,332
11-01-30 조회 5,419
11-01-14 조회 5,222
11-01-14 조회 3,771
11-01-14 조회 2,919
11-01-14 조회 2,956
11-01-14 조회 3,108
11-01-12 조회 2,880
11-01-07 조회 4,529
10-12-29 조회 2,544
10-12-22 조회 2,495
10-12-05 조회 5,903
10-11-22 조회 5,268
10-11-13 조회 3,641
10-10-27 조회 3,244
10-10-21 조회 2,942
10-09-21 조회 2,948
10-09-17 조회 3,005
10-09-15 조회 3,451
10-09-14 조회 4,052
10-05-18 조회 2,945
10-02-17 조회 4,387
10-02-12 조회 3,141
09-12-14 조회 5,205
09-12-14 조회 6,073
09-09-19 조회 4,423
09-08-16 조회 6,279
09-07-22 조회 5,686
09-04-13 조회 3,085
09-03-15 조회 5,097
09-03-05 조회 3,924
09-02-09 조회 2,874
08-12-30 조회 3,061
08-12-06 조회 3,257
08-11-30 조회 3,601
08-10-18 조회 4,443
08-10-08 조회 3,831
08-09-19 조회 4,403
08-09-05 조회 3,034
08-09-05 조회 5,132
08-09-05 조회 3,010
08-09-05 조회 3,618
08-09-05 조회 3,524
08-09-01 조회 4,541
08-08-07 조회 2,791
08-06-08 조회 3,256
08-06-02 조회 2,863
08-05-26 조회 5,280
08-05-09 조회 4,338
08-04-22 조회 3,951
08-04-17 조회 4,527
08-04-17 조회 5,599
08-04-17 조회 3,740
08-04-17 조회 8,728
08-04-17 조회 4,641
08-04-17 조회 4,552
08-04-09 조회 3,096
08-03-31 조회 3,578
08-03-26 조회 3,293
08-03-25 조회 3,582
08-03-25 조회 4,003
08-03-25 조회 4,034
08-03-25 조회 3,697
08-03-25 조회 3,593
08-03-25 조회 3,594
08-03-25 조회 5,286
08-02-03 조회 5,370
08-01-18 조회 6,665
08-01-17 조회 3,957
08-01-17 조회 3,775
08-01-12 조회 4,081
08-01-08 조회 3,388
07-12-28 조회 4,667
07-12-04 조회 3,552
07-11-30 조회 5,155
07-11-30 조회 5,756
07-11-02 조회 4,049
07-10-24 조회 4,033
07-10-24 조회 3,313
07-10-24 조회 3,423