웹쇼핑몰 : 상품 관리 테이블 생성 및 상품 등록하기

 

 

 

product.sql

-- webmarket
use webmarketdb;
create table product(
	p_id varchar(10) not null,
    p_name varchar(20),
    p_unitprice integer,
    p_description text,
    p_category varchar(30),
    p_manufacturer varchar(30),
    p_unitsinstock long,
    p_condition varchar(30),
    p_filename varchar(30),
    primary key(p_id)
) default charset=utf8;
desc product;
-- data 입력
-- insert into product values("","",1,"","","",1,"","");

insert into product values("P1234","iPhone 6s",800000,"1334X750 Renina HD display, 8-megapixel iSight Camera","Smart Phone","Apple",1000,"new","P1234.png");
insert into product values("P1235","LG PC gram",1500000,"3.3-inch, IPS LED display, 5rd Generation Intel Core processors","Notebook","LG",1000,"new","P1235.png");
insert into product values("P1236","Galaxy Tab S",900000,"3.3-inch, 212.8*125.6*6.6mm, Super AMOLED display, Octa-Core processor","Tablet","Samsung",1000,"new","P1236.png");

select * from product;

 

 

테이블 생성된 결과 조회