Python全栈（三）数据库优化之10.MySQL高级-表优化和索引优化

一、单表优化

建表：

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
);

打印

Query OK, 0 rows affected (0.05 sec)

插入数据：

insert into article(`author_id`,`category_id`,`views`,`comments`,`title`,`content`) values 
(1,1,1,1,'1','1'),
(2,2,2,2,'2','2'),
(1,1,3,3,'3','3');

打印

Query O