티스토리 뷰
아미나빌더 추천
select * from `g5_apms_like` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'
select * from `{$g5['apms_like']}` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'
delete from `g5_apms_like` where id ='글번호'
delete from `{$g5['apms_good']}` where id ='글번호'
아미나빌더 ( 영카트 ) 좋아요
select * from `g5_apms_good` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'
select * from `{$g5['apms_good']}` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'
delete from `g5_apms_like` where id ='글번호'
delete from `{$g5['apms_good']}` where id ='글번호'
그누보드5 좋아요
select * from `g5_board_good` where mb_id = '추천누른_회원ID' and bo_table = '게시판' and wr_id = '추천글_ID'
select * from `{$g5['board_good_table']}` where mb_id = '추천누른_회원ID' and bo_table = '게시판' and wr_id = '추천글_ID'
delete from `g5_board_good` where bg_id = '글번호''
delete from `{$g5['board_good_table']}` where bg_id = '글번호''
select * from `g5_apms_like` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'
select * from `{$g5['apms_like']}` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'
delete from `g5_apms_like` where id ='글번호'
delete from `{$g5['apms_good']}` where id ='글번호'
아미나빌더 ( 영카트 ) 좋아요
select * from `g5_apms_good` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'
select * from `{$g5['apms_good']}` where mb_id = '추천누른_회원ID' and to_id ='추천받은글작성_회원ID'
delete from `g5_apms_like` where id ='글번호'
delete from `{$g5['apms_good']}` where id ='글번호'
그누보드5 좋아요
select * from `g5_board_good` where mb_id = '추천누른_회원ID' and bo_table = '게시판' and wr_id = '추천글_ID'
select * from `{$g5['board_good_table']}` where mb_id = '추천누른_회원ID' and bo_table = '게시판' and wr_id = '추천글_ID'
delete from `g5_board_good` where bg_id = '글번호''
delete from `{$g5['board_good_table']}` where bg_id = '글번호''
'DBMS' 카테고리의 다른 글
MySQL 과 MariaDB 버전 별 호환성 (0) | 2024.09.04 |
---|---|
mysqldump: Got error: 144: Table ‘테이블명’ is marked as crashed and last (automatic?) repair failed when using LOCK TABLES 오류 발생 (0) | 2022.03.23 |
mysql - 중복 레코드 지우기 (0) | 2016.10.23 |
댓글