python implement mysql add delete check change サンプルコード

$ (node:10816) Warning: Accessing non-existent property 'lineno' of module exports inside circular dependency
bash: syntax error near unexpected token `Warning:'
(node:10816) Warning: Accessing non-existent property 'column' of module exports inside circular dependency
(node:10816) Warning: Accessing non-existent property 'filename' of module exports inside circular dependency
(node:10816) Warning: Accessing non-existent property 'lineno' of module exports inside circular dependency
(node:10816) Warning: Accessing non-existent property 'column' of module exports inside circular dependency
(node:10816) Warning: Accessing non-existent property 'filename' of module exports inside circular dependency
(node:10816) Warning: Accessing non-existent property 'lineno' of module exports inside circular dependency

node --trace-warnings queue.js 

(node:11572) Warning: Accessing non-existent property 'lineno' of module exports inside circular dependency
    at emitCircularRequireWarning (internal/modules/cjs/loader.js:814:11)
    at Object.get (internal/modules/cjs/loader.js:825:5)
    at Boolean.Node [as constructor] (\node_modules\stylus\lib\nodes\node.js:44:23)
    at new Boolean (\node_modules\stylus\lib\nodes\boolean.js:23:8)
    at Object.<anonymous> (\node_modules\stylus\lib\nodes\index.js:57:16)
    at Module._compile (internal/modules/cjs/loader.js:1185:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1205:10)
    at Module.load (internal/modules/cjs/loader.js:1034:32)
    at Function.Module._load (internal/modules/cjs/loader.js:923:14)
    at Module.require (internal/modules/cjs/loader.js:1074:19)
(node:11572) Warning: Accessing non-existent property 'column' of module exports inside circular dependency
    at emitCircularRequireWarning (internal/modules/cjs/loader.js:814:11)
    at Object.get (internal/modules/cjs/loader.js:825:5)
    at Boolean.Node [as constructor] (\node_modules\stylus\lib\nodes\node.js:45:23)
    at new Boolean (\node_modules\stylus\lib\nodes\boolean.js:23:8)
    at Object.<anonymous> (\node_modules\stylus\lib\nodes\index.js:57:16)
    at Module._compile (internal/modules/cjs/loader.js:1185:30)
    at Object.Module._extensions..js (internal/modules/cjs/loader.js:1205:10)
    at Module.load (internal/modules/cjs/loader.js:1034:32)
    at Function.Module._load (internal/modules/cjs/loader.js:923:14)
    at Module.require (internal/modules/cjs/loader.js:1074:19)

exports.lineno = null;
exports.column = null;
exports.filename = null;

'''
host hostname Here is your ip address 
user database account
password database password
port port mysql database port
db database name

Basic statements
cursor = conn.cursor()# initialize a cursor object

sql = "database operation statement"

cursor.execute(sql)#execute the statement

conn.commit()#close the cursor object

cursor.close()#close the database
rollback Rollback

'''

import pymysql
db = pymysql.connect(host='localhost',user='root',password='123456',port=3306,db='text')
sql = "update text set name='Xiaolin' where id=1"
# Get subscript
cursor = db.cursor()
try:
    cursor.execute(sql)
    db.commit()
    print(f'Modified successfully')

except:
    db.rollback()
    db.close()