Programming Archives - 25 중 10 번째 페이지

sql 스크립트 생성시에 옵션

[wp_graphviz simple="yes"] Hello->World->Graphviz->Rules; [/wp_graphviz]

1	[wp_graphviz simple="yes"] Hello->World->Graphviz->Rules; [/wp_graphviz]

[한글컬럼값 들어있는 것만 지우기]

select *  from tbl where field like '%[가-힣]%'
delete  from tbl where field like '%[가-힣]%'

1 2	select * from tbl where field like '%[가-힣]%' delete from tbl where field like '%[가-힣]%'

[영문컬럼값 들어있는 것만 지우기]

select * from tbl where field like '%[A-Za-z]%'
delete from tbl where field like '%[A-Za-z]%'

1 2	select * from tbl where field like '%[A-Za-z]%' delete from tbl where field like '%[A-Za-z]%'