create table blog(id int primary key not null auto_increment,type varchar(10),name varchar(10),num int(11),site varchar(10),content varchar(100))type=innodb;

回复内容： create table blog(id int primary key not null auto_increment,type varchar(10),name varchar(10),num int(11),site varchar(10),content varchar(100))type=innodb;

create table `blog` ( `id` int not null auto_increment, `type` varchar(10) null, `name` varchar(10) null, `num` int(11) null, `site` varchar(10) null, `content` varchar(100) null, primary key (`id`) ) engine=innodb default character set=utf8 collate=utf8_general_ci;
create table blog( id int primary key not null auto_increment, type varchar(10), name varchar(10), num int(11), site varchar(10), content varchar(100))engine=innodb;
用engine = innodb代替type = innodb。type在5.1版本已经废弃了。