python链接数据库每日自动更新_python连接MYSQL数据库，调用update语句后无法更新数据，求大神解决...

config={'host':'10.66.88.221',#连接的数据库IP地址'user':'root','password':'Changeme123','port':31900,#默认3306或31900'database':'MYSQL','charset':'utf8'#默认即为utf8}try:...

config={'host':'10.66.88.221',#连接的数据库IP地址

'user':'root',

'password':'Changeme123',

'port':31900 ,#默认3306或31900

'database':'MYSQL',

'charset':'utf8'#默认即为utf8

}

try:

conn = mysql.connector.connect(**config)#加载MYSQL数据库参数，建立连接。

curA = conn.cursor(buffered=True)

sql_Str="set names gb2312"#设置MYSQL数据库返回字符串的编码为gb2312

curA.execute(sql_Str)

count = 0

curA.execute("select * from omssm.t_securitylog;")

for rows in curA:

strRow = ''

for col in rows:

strRow += '\t' + str(col)

#print strRow

count += 1

Str_Sn = 10

sql_Update="update omssm.t_securitylog set DATETIME=0 where SN=%s;"

curA.execute(sql_Update,[Str_Sn,])

RESULTS=curA.fetchall()

print RESULTS

展开