모든데이터 가져오기
SELECT * FROM member
SELECT m_code, m_name, m_id, m_sex, m_age, m_email FROM member
---------------------------------------------------------------------
특정 컬럼 데이터 조회
SELECT m_name, m_code, m_sex FROM member
---------------------------------------------------------------------
특정 레코드(로우) 가져오기
SELECT m_name, m_code, m_sex FROM member
Where m_code=4
---------------------------------------------------------------------
코드가 5보다 작은 사람들 모두의 회원코드,이름,성별 가져오기
SELECT m_name, m_code, m_sex FROM member
Where m_code<5
---------------------------------------------------------------------
회원중 아이디가 jungwon 인 사람의 이름,코드,성별 가져오기
SELECT m_name, m_code, m_sex FROM member
Where m_name='jungwon'
---------------------------------------------------------------------
회원코드가 14보다작은 친구들중 나이가 28살인 친구들의 이름 ,아이디,성별 가져오기
SELECT m_name, m_id, m_sex, m_age FROM member
Where m_code<14 AND m_age=28
10살부터 20살 까지인 사람 가져오기
SELECT m_name, m_id, m_sex, m_age FROM member
Where m_age>=10 AND m_age<=20
같다 Where m_age BETWEEN 10 AND 20
---------------------------------------------------------------------
'김' 자로 시작하는 친구 검색
SELECT m_name, m_id, m_sex FROM member
Where m_name LIKE '김*'
---------------------------------------------------------------------
나이가 27 28 29 인 사람만 뽑기
SELECT m_name, m_id, m_age FROM member
Where m_age=27 OR m_age=28 OR m_age=29
같다 Where m_age IN (27,28,29)
---------------------------------------------------------------------
데이터 정렬
SELECT m_name, m_id, m_age FROM member
ORDER BY m_age ASC
---------------------------------------------------------------------
두개 이상의 컬럼으로 데이터 정렬
SELECT m_name, m_id, m_age, m_day FROM member
ORDER BY m_age ASC DESC, m_day DESC
----------------------------------------------------------------------
나이 평균
SELECT AVG(m_age) FROM member
갯수세기(null 값은 세지않음.)
SELECT COUNT(m_email) FROM member
중복되는값을 한번씩만 보여준다.
SELECT DISTINCT(m_age) FROM member
-----------------------------------------------------------------------
서브쿼리
SELECT m_name, m_id, m_age FROM member
WHERE m_age > Select AVG(m_age from member)
서브쿼리 정렬
SELECT m_name, m_id, m_age FROM member
WHERE m_age > Select AVG(m_age from member)
ORDER BY m_age DESC
-------------------------------------------------------------------------
데이터 삽입하기
INSERT INTO member
(m_id, m_name, m_sex, m_age, m_email)
VALUES
('nforce', '김정원', '남', 28, 'nforce7050@nate.com')
---------------------------------------------------------------------------
업데이트
UPDATE member
SET m_email = 'nforce7050@nate.com'WHERE m_name = '김정원'
----------------------------------------------------
전체 바꾸기
UPDATE member
SET m_age = m_age + 1
-----------------------------------------------------
삭제하기
DELETE FROM member
WHERE m_age = 28
-----------------------------------------------------
| 
___
