목록한방쿼리 (1)

Tech Log 🛠️

쿠팡 DB 설계 최종 , 한방 쿼리 예시

쿠팡 ERD URL : https://aquerytool.com/aquerymain/index/?rurl=d8467984-5fa4-491c-b567-1b1de339fc1c& Password : xy2cgb 한방 쿼리 - 내 정보 관리 use kiinDB; select name as 고객명, passwd as 비밀번호, email as 이메일, number as 연락처, address as 주소, profile_img as 프로필사진, concat(membership, '회원') as 멤버십 from user u inner join (select membership, user_id from membership) m on u.id = m.user_id inner join (select address, use..
Mysql , DB 2023. 1. 6. 23:01
이전 Prev 1 Next 다음