在此我们仍然后前面章节提到的 test 数据库，在test数据库里添加一个album表并插入数据，具体如下： ~~~ CREATE TABLE album(id int(10) NOT NULL AUTO_INCREMENT,title varchar(100) NOT NULL,artist varchar(1000) NOT NULL,PRIMARY KEY(id)); INSERT INTO news(title,artist) VALUES(‘First album’,’artist01’); INSERT INTO news(title,artist) VALUES(‘Second album’,’artist02’); INSERT INTO news(title,artist) VALUES(‘Third album’,’artist03’); INSERT INTO news(title,artist) VALUES(‘fourth album’,’artist04’); INSERT INTO news(title,artist) VALUES(‘Fifth album’,’artist05’); INSERT INTO news(title,artist) VALUES(‘Sixth album’,’artist06’); ~~~