예를들어
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =2 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =3 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =4 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =5 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =6 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =7 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =8 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =9 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =10 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =11 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =12 LIMIT 1 ;
회원디비의 2부터 12번까지 위에서처럼 일일히 선택하여 삭제하는거말고..
2번부터 12번까지 전부 삭제해라..
이렇게 퀴리문을 알고싶은데..
어떻게 써야해요?? 조언좀 부탁드립니다~
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =2 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =3 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =4 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =5 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =6 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =7 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =8 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =9 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =10 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =11 LIMIT 1 ;
DELETE FROM `g4_member` WHERE `g4_member`.`mb_no` =12 LIMIT 1 ;
회원디비의 2부터 12번까지 위에서처럼 일일히 선택하여 삭제하는거말고..
2번부터 12번까지 전부 삭제해라..
이렇게 퀴리문을 알고싶은데..
어떻게 써야해요?? 조언좀 부탁드립니다~
댓글 4개
게시글 목록
| 번호 | 제목 |
|---|---|
| 284348 | |
| 284336 | |
| 284333 | |
| 284332 | |
| 284320 | |
| 284318 | |
| 284316 | |
| 284313 | |
| 284307 | |
| 284306 | |
| 284303 | |
| 284298 | |
| 284296 | |
| 284290 | |
| 284286 | |
| 284280 | |
| 284277 | |
| 284272 | |
| 284261 | |
| 284259 |
댓글 작성
댓글을 작성하시려면 로그인이 필요합니다.
로그인하기