서

mysql select 후 update 하기

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

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-11 조회 3,051
16-05-12 조회 3,308
16-04-12 조회 3,191
16-02-03 조회 2,944
16-02-03 조회 2,991
16-02-02 조회 3,287
16-02-01 조회 2,672
16-02-01 조회 2,648
16-01-31 조회 2,678
16-01-31 조회 2,684
16-01-31 조회 2,701
16-01-30 조회 2,688
16-01-29 조회 2,684
16-01-29 조회 2,576
16-01-29 조회 2,561
16-01-28 조회 2,510
16-01-28 조회 2,418
16-01-27 조회 2,573
16-01-27 조회 2,563
16-01-26 조회 2,549
16-01-25 조회 2,620
16-01-25 조회 2,492
16-01-24 조회 2,493
16-01-24 조회 2,485
16-01-24 조회 2,412
16-01-23 조회 2,460
16-01-23 조회 2,477
16-01-23 조회 2,449
16-01-22 조회 2,681
16-01-21 조회 2,714
16-01-21 조회 2,576
16-01-21 조회 2,544
16-01-20 조회 2,493
16-01-20 조회 2,446
16-01-20 조회 2,457
16-01-19 조회 2,484
16-01-19 조회 2,548
16-01-18 조회 2,532
16-01-16 조회 2,467
16-01-16 조회 2,396
16-01-16 조회 2,453
16-01-15 조회 2,610
16-01-15 조회 2,612
16-01-15 조회 2,532
16-01-15 조회 2,465
16-01-14 조회 2,506
16-01-14 조회 2,745
16-01-14 조회 2,554
16-01-13 조회 2,573
16-01-13 조회 2,588
16-01-13 조회 2,481
16-01-12 조회 2,671
16-01-11 조회 2,719
16-01-11 조회 2,657
16-01-11 조회 2,435
16-01-02 조회 2,887
15-12-31 조회 2,585
15-12-27 조회 2,683
15-12-27 조회 2,581
15-12-27 조회 2,639
15-12-26 조회 2,601
15-12-26 조회 2,675
15-12-26 조회 2,697
15-12-25 조회 3,469
15-12-25 조회 2,559
15-12-25 조회 2,568
15-12-25 조회 2,515
15-12-24 조회 3,063
15-12-23 조회 2,532
15-12-23 조회 2,661
15-12-23 조회 2,611
15-12-22 조회 2,655
15-12-22 조회 2,630
15-12-22 조회 2,537
15-12-21 조회 2,563
15-12-21 조회 2,588
15-12-21 조회 2,568
15-12-20 조회 2,619
15-12-20 조회 2,786
15-12-20 조회 2,552
15-12-19 조회 2,636
15-12-19 조회 2,625
15-12-19 조회 2,639
15-12-18 조회 2,985
15-12-18 조회 2,605
15-12-18 조회 2,595
15-12-18 조회 2,573
15-12-17 조회 2,561
15-12-17 조회 2,584
15-12-17 조회 2,546
15-12-16 조회 2,554
15-12-16 조회 2,591
15-12-16 조회 2,532
15-12-15 조회 2,543
15-12-15 조회 2,542
15-12-15 조회 2,535
15-12-14 조회 2,596
15-12-14 조회 2,687
15-12-14 조회 2,511
15-12-13 조회 2,476