python 插入数据库的写法

Black 
sql = "INSERT INTO `%s` (id,article_id,title,content,category,articleUrl,crawlSign,publishSign) VALUES (NULL,'%s','%s','%s','%s','%s','%s','%s')" % (
                TABLE_NAME, information['article_id'], information['title'], information['content'],
                information['category'], information['articleUrl'], information['crawlSign'],
                information['publishSign'])
                await cur.execute(sql)

Related Posts