엑

insert에서 where 사용하기

· 2008-12-06 (토) 22:30:12 · 3254
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건
+
제목 글쓴이 날짜 조회
09-07-11 조회 2,943
09-07-11 조회 3,169
09-06-29 조회 3,558
09-06-26 조회 5,178
09-06-25 조회 4,120
09-06-25 조회 2,793
09-06-18 조회 5,345
09-06-17 조회 2,685
09-06-15 조회 2,904
09-06-15 조회 2,539
09-06-15 조회 3,061
09-06-15 조회 2,943
09-06-15 조회 2,973
09-06-15 조회 2,822
09-06-09 조회 3,512
09-05-29 조회 3,108
09-05-29 조회 3,242
09-05-28 조회 3,548
09-05-22 조회 2,949
09-05-16 조회 3,795
09-05-14 조회 3,522
09-05-11 조회 5,882
09-05-08 조회 2,632
09-05-06 조회 2,339
09-05-05 조회 3,405
09-05-04 조회 3,256
09-05-01 조회 2,845
09-04-30 조회 3,394
09-04-30 조회 3,759
09-04-18 조회 2,682
09-04-17 조회 3,072
09-04-13 조회 3,279
09-04-13 조회 2,326
09-04-13 조회 3,082
09-04-13 조회 2,683
09-04-10 조회 3,202
09-04-10 조회 2,625
09-04-07 조회 3,617
09-04-04 조회 3,254
09-04-02 조회 7,221
09-03-19 조회 3,227
09-03-15 조회 5,091
09-03-15 조회 2,729
09-03-13 조회 3,029
09-03-10 조회 3,374
09-03-05 조회 3,922
09-03-05 조회 3,642
09-02-27 조회 4,164
09-02-23 조회 4,411
09-02-23 조회 4,419
09-02-21 조회 3,182
09-02-21 조회 2,814
09-02-17 조회 2,774
09-02-17 조회 3,157
09-02-17 조회 2,539
09-02-17 조회 3,342
09-02-17 조회 3,065
09-02-13 조회 2,853
09-02-09 조회 2,649
09-02-09 조회 3,495
09-02-09 조회 4,548
09-02-09 조회 3,611
09-02-09 조회 3,107
09-02-09 조회 2,873
09-02-05 조회 3,352
09-02-03 조회 6,112
09-01-30 조회 2,863
09-01-25 조회 3,545
09-01-24 조회 3,661
09-01-23 조회 3,831
09-01-23 조회 3,452
09-01-20 조회 5,843
09-01-20 조회 4,280
09-01-17 조회 4,278
09-01-17 조회 2,945
09-01-15 조회 2,533
09-01-14 조회 5,249
09-01-10 조회 3,068
09-01-09 조회 2,958
09-01-08 조회 3,470
09-01-08 조회 3,225
09-01-06 조회 2,894
09-01-05 조회 5,157
08-12-30 조회 3,057
08-12-30 조회 4,479
08-12-29 조회 4,332
08-12-27 조회 2,323
08-12-27 조회 3,183
08-12-27 조회 2,834
08-12-27 조회 3,129
08-12-20 조회 3,902
08-12-20 조회 4,277
08-12-13 조회 4,513
08-12-12 조회 4,578
08-12-12 조회 2,684
08-12-11 조회 2,694
08-12-10 조회 3,505
08-12-06 조회 3,255
08-11-30 조회 3,601
08-11-27 조회 4,151