SELECT COUNT( *) as "Number of Rows" FROM orders;
我想将“行数”添加到python变量中,但idk如何添加。
python变量中存储的行数
db= MySQLdb.connect("HOSTNAME", "USER_NAME", "PWD", "DB_NAME"); cursor= db.cursor(); number_of_rows = cursor.execute("SELECT COUNT (*) FROM TBL"); print(number_of_rows);
