mysql - 请用外行术语解释 cursor.execute。另外，如何打印 cursor.execute 的结果

Question

 import mysql.connector as conn

 mydb = conn.connect(
 host="localhost",
 user="root",
 passwd="password",
 database="python_mysql"
 )

 mycursor = mydb.cursor()

计算数据库“python_mysql”中的表数

  mycursor.execute("SELECT FOUND_ROWS();") #This contains 3 as result

如何将结果打印为 3 通过将其放入新变量中

标签： mysqlpython-3.x

Answer 1

通过获取和分配我们可以得到计数

mycursor.execute("SELECT FOUND_ROWS();") 
data = mycursor.fetchall()
print(data[0][0]) # prints 3