서

mysql select 후 update 하기

· 2016-03-09 (수) 13:43:34 · 2984

update tbl_a

set no = 'a'

where seq in (select * from ( select seq from tbl_a where x = 'b' ) as t )

|
댓글을 작성하시려면 로그인이 필요합니다.

프로그램

8,188건
+
제목 글쓴이 날짜 조회
16-06-30 조회 2,895
16-05-11 조회 3,435
16-03-21 조회 3,190
16-03-19 조회 3,124
16-03-17 조회 2,956
16-03-17 조회 3,021
16-03-14 조회 3,040
16-03-13 조회 2,981
16-03-09 조회 3,422
16-03-08 조회 3,052
16-03-08 조회 2,856
16-03-08 조회 2,875
16-03-08 조회 3,027
16-03-07 조회 2,815
16-03-07 조회 2,811
16-02-29 조회 3,219
16-02-25 조회 3,198
16-02-22 조회 3,003
16-02-12 조회 3,299
16-02-04 조회 3,125
16-02-04 조회 3,395
16-02-04 조회 3,034
16-02-03 조회 3,196
16-02-03 조회 3,011
16-02-02 조회 2,961
16-02-02 조회 2,852
16-02-01 조회 2,853
16-01-30 조회 2,684
16-01-30 조회 2,872
16-01-30 조회 2,965
16-01-30 조회 2,792
16-01-29 조회 2,664
16-01-28 조회 2,978
16-01-28 조회 2,813
16-01-27 조회 2,572
16-01-26 조회 2,551
16-01-26 조회 2,638
16-01-25 조회 2,600
16-01-22 조회 2,583
16-01-22 조회 2,665
16-01-21 조회 2,576
16-01-19 조회 2,487
16-01-19 조회 2,527
16-01-18 조회 2,507
16-01-17 조회 2,682
16-01-14 조회 2,602
16-01-13 조회 2,798
16-01-12 조회 2,901
16-01-12 조회 2,645
16-01-11 조회 2,637
15-12-30 조회 3,226
15-12-29 조회 2,603
15-12-28 조회 2,632
15-12-09 조회 2,700
15-12-08 조회 2,904
15-12-08 조회 2,655
15-12-08 조회 2,930
15-12-07 조회 2,734
15-12-07 조회 3,116
15-12-07 조회 2,761
15-12-06 조회 2,884
15-12-06 조회 2,597
15-12-06 조회 2,836
15-12-05 조회 2,763
15-12-05 조회 3,017
15-12-05 조회 2,787
15-12-04 조회 2,652
15-12-04 조회 2,760
15-12-04 조회 2,820
15-12-03 조회 2,770
15-12-03 조회 2,798
15-12-03 조회 2,837
15-12-02 조회 2,923
15-12-02 조회 2,854
15-12-02 조회 3,007
15-12-02 조회 3,053
15-12-01 조회 2,741
15-12-01 조회 2,535
15-12-01 조회 2,616
15-11-30 조회 2,804
15-11-30 조회 2,961
15-11-30 조회 2,861
15-11-29 조회 2,629
15-11-29 조회 2,886
15-11-29 조회 2,688
15-11-28 조회 2,623
15-11-28 조회 2,652
15-11-28 조회 2,685
15-11-27 조회 2,774
15-11-27 조회 2,630
15-11-27 조회 2,645
15-11-25 조회 2,728
15-11-25 조회 2,781
15-11-25 조회 2,579
15-11-23 조회 2,849
15-11-23 조회 2,996
15-11-23 조회 2,823
15-11-21 조회 2,718
15-11-21 조회 2,615
15-11-21 조회 2,560