[MySQL] DBMS SLELECT FROM WHERE

• SELECT = READ
• FK (forigen key)

새 쿼리탭 열기

• From : 테이블_이름
• where : 조건식

*클라이언트로 부터 받은 요청을 처리하고 응답 하는 것이 서버다.

 

use market_db;

SELECT * From member; #전체 테이블

SELECT mem_id FROM member; # 멤버 아이디만
SELECT mem_name FROM member;
desc member;

Select mem_name ,addr from member;

select addr "주소", debut_date "데뷔 일자"
from member;

Select mem_name from member
where mem_name = '블랙핑크';

SELECT mem_name "이름" , height "키" FROM MEMBER
WHERE  height >= 165 AND height < 168 # OR (|| 랑비슷)
ORDER BY height DESC;

select mem_name , height from  member
where height Between 163 and 165;

select * from member
where addr in('서울','경기')
and mem_name = '에이핑크';


select * from member 
where mem_name LIKE '우%';


select * from member 
where mem_name LIKE '__핑크' # 언더바 두개 _ _ 뭐든 두글자 들어갈수 있음
and addr = '경기';

select * from member
where mem_name like '__이스';

select height from member
where mem_name = '블랙핑크';
select height from member
where height >= 164;

select mem_name , height from member
where height in(select height from member where mem_name = '에이핑크');

select mem_name, debut_date
from member
order by debut_date ;

select mem_name, height , debut_date
from member
where height >= 164
order by height desc, debut_date ASC
limit 2 , 2;

select Distinct addr from member # 중복 제거
order by addr asc;

select * from buy;

select mem_id, amount from buy;
select mem_id ,sum(amount) "구매갯수" from buy
group by mem_id;

desc buy;

select mem_id,sum(price * amount) from buy
group by mem_id
order by sum(price * amount) asc
limit 3;

select mem_id "멤버 아이디" , round(avg(amount)) "평균" from buy;

select * from buy
group by mem_id;

select mem_id '회원 아이디', round(avg(amount)) from buy
group by mem_id;

select count(*) 'count' from member; # 변수 명으로 별칭으로 사용 가능하니 기억해 둘것 

select * from member;
select phone1 , phone2 from member;

select count(phone1) , count(phone2) from member;

select mem_id'팀 이름' , sum(price * amount) from buy
#where sum(price * amount) > 1000 # 안되니까 having 써라
group by mem_id
having sum(price * amount) > 1000
order by sum(price*amount) asc;

 

select , from, where , order by , group by, having , in ,and ,or, Between, limit

 

오늘 배운 MySQL 명령어들 이니 기억할 것.