본문 바로가기

select

[MYSQL] update ...select 구문. 삽질하다가 OK [MYSQL] update ...select 구문. 삽질하다가 OK #mysql #database #update #select 아래처럼 해야함. update wp_moa_bible_mcheyne m join wp_moa_bible_sort s on s.name_short = m.sort_name set m.ever_seq_no = s.ever_seq_no ; 아래처럼 계속 하면 삽질만 한다. update wp_moa_bible_mcheyne a set ever_seq_no = ( select ever_seq_no from wp_moa_bible_sort b where a.sort_name = b.name_short ); update wp_moa_bible_mcheyne m, wp_moa_bible_sor.. 더보기
[JAVASCRIPT] select 관리 http://igor10k.github.io/ikSelect/ Stylize selects across all browsers with little effort. Features custom syntax support works perfect as an inline-block no z-index bugs in IE optgroups support great API add/remove 's and 's disable/enable anything (select, optgoup, option) optional filter text field can be used with hidden parents compatible with mobile devices behavior is as authentic as poss.. 더보기