1. 서버설치(서버구축)

2. DataBase생성.
DataBase : Data를 저장할 수 있는 저장소.
DataBase Management System: DataBase 를 관리하는 프로그램.

DataBase System : DataBase + DBMS + User(관리자,개발자,사용)
* DataBase System 을 DBMS와 같은 개념으로 보기도 함.

* 근래에는 DataBase를 DataBase System을 가리키는 말로 사용.

create database company;  

SQL(Structured Query Language) : R(Relational)DB에서 
사용하는 범용적 언어.


3. Table생성

use company;

create table products(
	id int not null auto_increment primary key,
	name varchar(50) not null,
	modelnumber varchar(15) not null,
	series varchar(30) not null
);

4. 자료입력

insert into products(name,modelnumber,series) 
values('eric','1234567','Aritist');
insert into products(name,modelnumber,series)
values('Jeff','1234568','Artist');
insert into products(name,modelnumber,series)
values('American','1234569','American Deluxe');

5. 자료조회

select * from products;

select id, name from products;

select * from products
where series='Artist';

select * from products
where id>1 and id<5; -- id가 1보다크고 5보다 작은 행 검색.

select * from products
where id<2 or id>3;

select * from products order by name asc; -- 오름차순
select * from products order by name desc; -- 내림차순

-- 3번째부터 2개
select * from products order by name desc limit 2,2;
-- 첫번째부터 2개
select * from products order by name desc limit 2;

--특정 단어가 포함된 문자열 검색
select * from products where name like '%tom%;
-- ex: 게시판 제목에서 'html5' 검색
select * from board where title like '%html5%';


6. 데이터수정
update products set name='david' where id=1;

update products set name='jeff', modelnumber='777777'
where id=1;


7. 데이터삭제
delete from products where id=1;