DB16 Row size too large (> 8126) 해결법 보호되어 있는 글 입니다. 2020. 7. 26. MYSQL 데이터 삭제 ex) DELETE FROM `joke` WHERE `joketext` LIKE "%참%"; DELETE FROM `테이블명` WHERE 조건; *테이블 하나 통째로 삭제하기 DELETE FROM `테이블명`; 2020. 7. 12. MYSQL 데이터 수정 ex) UPDATE `joke` SET `jokedate` = "2020-06-01" WHERE id="1"; UPDATE `테이블명` SET `컬럼` = "바꿀내용" WHERE id="1"; ex) UPDATE `joke` SET `jokedate` = "2020-06-30" WHERE `joketext` LIKE "%참%"; UPDATE `테이블명` SET `컬럼1` = "2020-06-30" WHERE `컬럼2` LIKE "%참%"; 2020. 7. 12. MYSQL 다중 검색 명령어 ex) SELECT `joketext` FROM `joke` WHERE `joketext` LIKE "%참%" AND `jokedate` >= "2020-01-01" AND `jokedate` = "2020-01-01" AND `컬럼2` < "2020-07-30"; 2020. 7. 12. 이전 1 2 3 4 다음