python 爬取古诗文存入mysql数据库的方法

使用正则提取数据，请求库requests,看代码，在存入数据库时，报错ERROR 1054 (42S22): Unknown column ‘title’ in ‘field list’。原来是我写sql 有问题，sql = “insert into poem(title,author,content,create_time) values({},{},{},{})”.format(title, author,content,crate_time) 应该写成sql = “insert into poem(title,author,content,create_time) values('{}'