테이블 정보 다 보기
show tables
테이블 내의 전체 정보
select * from [테이블 이름];
테이블 내의 일부 정보
select [컬럼 명], [컬럼명] from [테이블 이름];
select * from orders where payment_method = 'kakaopay';
select * from orders where point > 5000;
select * from point_users where point > 20000;
select * from users where name = '황**';
select * from orders where course_title = '웹개발 종합반' and payment_method = 'CARD';
≠ - 부정문
select * from orders where course_title != '웹개발 종합반';
between - 사잇값
select * from orders where created_at between '2020-07-13' and '2020-07-15';
# 7/13 ~ 7/14
in - 포함되어있을 때
select * from checkins where week in (1, 3);
# week 가 1 또는 3
like - 문자 중 일부
select * from users where email like '%daum.net';
select * from orders where payment_method != 'CARD';
select * from point_users where point between 20000 and 30000;
select * from users where email like 's%com';
select * from users where email like 's%com' and name like '이%';
limit - 볼 수 있는 데이터 갯수 제한
select * from orders
where pament_method = 'kakaopay'
limit 5;
distinct - 중복 제거
select distinct(payment_method) from orders;
count
select count(*) from orders
where payment_method = 'kakaopay';
distinct & count
select count(distinct(name)) from users;
select email from users where name like '남%';
select * from users
where email like '%gmail.com'
and created_at between '2020/07/12' and '2020/07/14';
select count(*) from users
where email like '%gmail.com'
and created_at between '2020/07/12' and '2020/07/14';
select * from orders
where email like '%naver.com'
and course_title = '웹개발 종합반'
and payment_method = 'kakaopay';
