时间戳

首页 > 解决方案 > 属性错误：“NoneType”对象在 Python 中没有属性“光标”

python - 属性错误：“NoneType”对象在 Python 中没有属性“光标”

问题描述

我有这个代码

from flask_mysqldb import MySQL
app.config['MYSQL_HOST'] = 'localhost'
app.config['MYSQL_USER']='root'
app.config['MYSQL_PASSWORD']=''
app.config['MYSQL_DB']='appdb'
mysql = MySQL(appdb)
cursor = mysql.connection.cursor()
cursor.execute("SELECT id FROM table WHERE id='Apple'")
apple= cursor.fetchone()
cursor.close()

但是，我收到此错误

属性错误：Nonetype 对象没有属性“光标”

如何解决这个错误？

标签： pythonattributeerrormysql-connector

解决方案

from sqlalchemy import create_engine
from sqlalchemy.orm import close_all_sessions
import mysql.connector
import time

username = 'MYSQL_USER'
password = 'MYSQL_PASSWORD!'
host = 'MYSQL_HOST'
port = 'MYSQL_port'
DB_NAME = 'MYSQL_DBname'

engine = create_engine(f"mysql+mysqlconnector://{username}:{password}@{host}:{port}")

n = 250
for i in range(0,vac.shape[0],n):
    with engine.connect() as conn:
        result = conn.execute("USE MYSQL_DBname")
        result = conn.execute(""SELECT id FROM table WHERE id='Apple'"")

试试这个

推荐阅读