René's URL Explorer Experiment

Title: demo5.py · Issue #2 · Python3WebSpider/MySQLTest · GitHub

Open Graph Title: demo5.py · Issue #2 · Python3WebSpider/MySQLTest

X Title: demo5.py · Issue #2 · Python3WebSpider/MySQLTest

Description: 原书例子 sql = 'INSERT INTO {table}({keys}) VALUES ({values}) ON DUPLICATE KEY UPDATE'.format(table=table, keys=keys, values=values) update = ','.join(["{key} = %ss".format(key=key) for key in data]) 执行无法插入报错，修改为 sql = 'INSERT INTO {table}({...

Open Graph Description: 原书例子 sql = 'INSERT INTO {table}({keys}) VALUES ({values}) ON DUPLICATE KEY UPDATE'.format(table=table, keys=keys, values=values) update = ','.join(["{key} = %ss".format(key=key) for key in data]) 执...

X Description: 原书例子 sql = 'INSERT INTO {table}({keys}) VALUES ({values}) ON DUPLICATE KEY UPDATE'.format(table=table, keys=keys, values=values) update = ','.join(["{key} = %ss".format(ke...

Opengraph URL: https://github.com/Python3WebSpider/MySQLTest/issues/2

X: @github

direct link

Domain: patch-diff.githubusercontent.com

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"demo5.py ","articleBody":"原书例子\r\n```\r\nsql = 'INSERT INTO {table}({keys}) VALUES ({values}) ON DUPLICATE KEY UPDATE'.format(table=table, keys=keys, values=values)\r\nupdate = ','.join([\"{key} = %ss\".format(key=key) for key in data])\r\n```\r\n执行无法插入报错，修改为\r\n```\r\nsql = 'INSERT INTO {table}({keys}) VALUES ({values}) ON DUPLICATE KEY UPDATE '.format(table=table, keys=keys, values=values)\r\nupdate = ','.join([\"{key} = %s\".format(key=key) for key in data])\r\n```","author":{"url":"https://github.com/zhu-jie","@type":"Person","name":"zhu-jie"},"datePublished":"2021-12-26T12:20:42.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/2/MySQLTest/issues/2"}

Links:

Viewport: width=device-width