간단한 쿼리인데 에러가 왜 나는지 모르겠어요 ㅜㅜ;
- 쿼리문 -
CREATE TABLE member (
uid INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
id varchar(20) NOT NULL,
pw varchar(41) NOT NULL,
nick varchar(8) NOT NULL,
group int(8),
email varchar(60),
homepage varchar(60),
birth date,
comment text(200),
join_date datetime,
login_date datetime,
login_ip varchar(15),
modify_ip varchar(15),
join_ip varchar(15)
)
- 에러내용 -
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group int(8),
email varchar(60),
homepage varchar(60),
birth date,
comment text(' at line 6