◆ tbl_member - 회원 테이블 생성 > SPRING1

• 목록

create table tbl_member (

userid varchar(50) not null,

userpw varchar(50) not null,

username varchar(50) not null,

email varchar(100) default '',

regdate varchar(20) default '',

level varchar(2) default '1',

primary key(userid)

);

insert into tbl_member values ('1111','1111','일돌이','1111@1111.com',now(),'10');