JSON writes to MySQL via Pymysql

1 #Coding=utf-82 3 ImportJSON4 ImportPymysql5 6db = Pymysql.connect ("localhost","Root","asdfg48520.","Test", Use_unicode=true, charset="UTF8")7cursor =db.cursor ()8sql ="""DROP TABLE IF EXISTS SHUJU1"""9 cursor.execute (SQL)Ten  Onesql ="""CREATE TABLE SHUJU1 ( A TITLE VARCHAR () not NULL, - Time VARCHAR (+), - textt VARCHAR (+), the URL VARCHAR ($))""" - cursor.execute (SQL) - Db.commit () -data = [] +  -With open (r'C:/users/18341/temp/shixi/10.21/pc1.json') as F: +      forLineinchF: A data.append (Json.loads (line)) at  -  forIteminchData: -Sql="""INSERT into SHUJU1 (title,time,textt,url) VALUES (%s,%s,%s,%s)""" -Cursor.execute (SQL, (item[' Time'],item['URL'],item['title'],item['text'])) -  - Db.commit () inDb.close ()

JSON writes to MySQL via Pymysql