code:
import pymysql.cursors
connection = pymysql.connect(host='localhost',
user='root',
password='123456',
db='wikiurl',
charset='utf8mb4')
try:
with connection.cursor() as cursor:
sql = "select urlname, urlhref from urls where id is not null"
conut = cursor.execute(sql)
print(conut)
finally:
connection.close()
This code in 0.7.6 is OK, but in 0.7.7 or 0.7.8 is not ok.
I think is, id is not null in 0.7.7 is not supported.
code:
This code in 0.7.6 is OK, but in 0.7.7 or 0.7.8 is not ok.
I think is,
id is not nullin 0.7.7 is not supported.