[SQL] 테이블 기획

테이블 기획

• Product table 생성

• Category table 생성

• 데이터 추가 쿼리

• 수정 쿼리

• 삭제 쿼리

• 상품리스트 쿼리

SELECT s_category.category, shopping.img, shopping.title, shopping.price, shopping.sale, shopping.reviewCount, shopping.likeCount, shopping.shoppingCount, shopping.etc
FROM shopping
LEFT JOIN s_category
ON shopping.category = s_category.id

• 인기순 정렬 쿼리

SELECT s_category.category, shopping.img, shopping.title, shopping.price, shopping.buy_count, shopping.sale, shopping.reviewCount, shopping.likeCount, shopping.shoppingCount, shopping.etc
FROM shopping
LEFT JOIN s_category
ON shopping.category = s_category.id
order by buy_count DESC;

• 오픈순 정렬 쿼리

SELECT s_category.category, shopping.img, shopping.title, shopping.price, shopping.openDate, shopping.sale, shopping.reviewCount, shopping.likeCount, shopping.shoppingCount, shopping.etc
FROM shopping
LEFT JOIN s_category
ON shopping.category = s_category.id
order by openDate DESC;