예를들어
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개
게시글 목록
| 번호 | 제목 |
|---|---|
| 284508 | |
| 284499 | |
| 284492 | |
| 284490 | |
| 284484 | |
| 284481 | |
| 284478 | |
| 284476 | |
| 284474 | |
| 284472 | |
| 284470 | |
| 284458 | |
| 284457 | |
| 284454 | |
| 284453 | |
| 284447 | |
| 284446 | |
| 284444 | |
| 284441 | |
| 284440 |
댓글 작성
댓글을 작성하시려면 로그인이 필요합니다.
로그인하기