CREATE TABLE member (
no int(20) not null default 0 auto_increment,
id varchar(32) not null,
pwd varchar(64) not null,
name varchar(32) not null,
email varchar(200) not null,
homeurl varchar(200),
sex varchar(1) not null,
birthtype varchar(1) not null,
birthyear varchar(4) not null,
birthmonth varchar(2) not null,
birthday varchar(2) not null,
zip1 varchar(3) not null,
zip2 varchar(3) not null,
address1 varchar(200) not null,
address2 varchar(200),
tel1 varchar(3),
tel2 varchar(4),
tel3 varchar(4),
phone1 varchar(3),
phone2 varchar(4),
phone3 varchar(4),
job varchar(200),
hobby varchar(200),
regdate datetime,
primary key(no,id)
);
=====> 테이블 생성시 유효하지 못한 디폴트값이란 오류가 납니다. 도와주세요 ㅠㅠ
완전 초보입니다..
|