单表优化 建表 create table article( id int unsigned not null primary key auto_increment, author_id int unsigned not null, category_id int unsigned not null, views int unsigned not null, comments int unsigned not null, title varchar(255) not null, content text not null ); 插入数据 insert into article