def create_table_books(self):
query = """DROP TABLE IF EXISTS `books`;
CREATE TABLE `books` (
`id` int(8) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`publishing_year` varchar(4) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;"""
for result in self.cursor.execute(query, multi=True):
self.connection.commit()