관리 메뉴

moozi

6/17 sql group by 본문

TIS_2016/HTML5_2기

6/17 sql group by

moozi 2016. 6. 17. 10:25

use school;

create table products(
 productId char(4) not null primary key,
 productName varchar(50) not null,
 productType varchar(10) not null,
 price int not null,
 expire varchar(10) null
);


insert into products(productId,productName,productType,price)
values('0001','아이폰6','smartphone',1000000);
insert into products(productId,productName,productType,price)
values('0002','갤럭시s7','smartphone',1000000);
insert into products(productId,productName,productType,price)
values('0003','닥터드레','headphone',200000);
insert into products(productId,productName,productType,price)
values('0004','뱅앤올룹슨','headphone',300000);
insert into products(productId,productName,productType,price)
values('0005','아이리버','mp3',500000);


select * from products;


 

'TIS_2016 > HTML5_2기' 카테고리의 다른 글

ajax 연습  (0) 2016.06.17
6/17 xml parsing  (0) 2016.06.17
6/17 sql group by  (0) 2016.06.17
sql연습문제01풀이  (0) 2016.06.17
sql연습문제01  (0) 2016.06.16
sql 기초2  (0) 2016.06.16
0 Comments
댓글쓰기 폼