문제 : 테이블 생성시, 에러가 발생
원인 : auto_increment를 사용할 경우 default를 지정하지 않음.
해결 : uid int unsigned default 0 auto_increment
à uid int unsigned auto_increment
<에러 발생 SQL문>
mysql> create table t1_board(
-> uid int unsigned default 0 auto_increment,
-> gid int unsigned default 0,
-> depth varchar(255) default 'A',
-> name varchar(20) not null,
-> email varchar(50),
-> passwd varchar(10) not null,
-> suject varchar(255) not null,
-> article text not null,
-> writedate char(10) not null,
-> refnum int unsigned default 0,
-> Primary key(uid)
-> );
ERROR 1067 (42000): 'uid'의 유효하지 못한 디폴트 값을 사용하셨습니다.
< 정상 실행 화면 >
mysql> create table t1_board(
-> uid int unsigned auto_increment,
-> gid int unsigned default 0,
-> depth varchar(255) default 'A',
-> name varchar(20) not null,
-> email varchar(50),
-> passwd varchar(10) not null,
-> suject varchar(255) not null,
-> article text not null,
-> writedate char(10) not null,
-> refnum int unsigned default 0,
-> Primary key(uid)
-> );
Query OK, 0 rows affected (0.22 sec)