Notice
Recent Posts
Recent Comments
Link
목록쿠팡ERD (1)
Tech Log 🛠️
![](http://i1.daumcdn.net/thumb/C150x150.fwebp.q85/?fname=https://blog.kakaocdn.net/dn/xsHOp/btrVzZZrOsY/2aobMq9BmKyILJJrhBjoak/img.png)
쿠팡 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