请教：用MySQL创建表单出错

Question

create table article default charset utf8 COLLATE utf8_general_ci
(
id int primary key auto_increment,
pid int,
rootid int,
title varchar(255),
cont text,
pdate datetime,
isleaf int
);

Answer 1

create table article
(
id int primary key AUTO_INCREMENT,
pid int,
rootid int,
title varchar(255),
cont text,
pdate datetime,
isleaf int
) default charset utf8 COLLATE utf8_general_ci;