mysql 개행문자 엔터등 삭제
페이지 정보
작성자 미친새 작성일 20-02-21 17:24 조회 15,157 댓글 0본문
UPDATE swearword SET swearword = REPLACE(swearword, '\r\n','');
UPDATE swearword SET swearword = REPLACE(swearword, '\n','');
UPDATE swearword SET swearword = REPLACE(swearword, CHAR(13),'');
중복 데이터 삭제
DELETE n1 FROM test.board n1, test.board n2 WHERE n1.idx > n2.idx AND n1.user_name = n2.user_name;
UPDATE swearword SET swearword = REPLACE(swearword, '\n','');
UPDATE swearword SET swearword = REPLACE(swearword, CHAR(13),'');
중복 데이터 삭제
DELETE n1 FROM test.board n1, test.board n2 WHERE n1.idx > n2.idx AND n1.user_name = n2.user_name;
관련링크
- https://curryyou.tistory.com/68 4282회 연결
댓글목록 0
등록된 댓글이 없습니다.