作者:用户9o05le1po7 | 来源:互联网 | 2023-09-14 09:29
如何用 Python 统计给定 SQLite 表的行数?
原文:https://www . geeksforgeeks . org/如何使用 python 计算给定 sqlite 表的行数/
在本文中,我们将讨论如何使用 Python 计算给定 SQLite 表的行数。我们将使用 cursor_obj.fetchall() 方法来做同样的事情。此方法获取查询结果的所有行。它以元组列表的形式返回所有行。如果没有要提取的记录,将返回一个空列表。
为了创建数据库,我们将执行以下代码:
python 3
import sqlite3
# Connecting to sqlite
# connection object
connection_obj = sqlite3.connect('geek.db')
# cursor object
cursor_obj = connection_obj.cursor()
# Drop the GEEK table if already exists.
cursor_obj.execute("DROP TABLE IF EXISTS GEEK")
# Creating table
table = """ CREATE TABLE GEEK (
Email VARCHAR(255) NOT NULL,
Name CHAR(25) NOT NULL,
Score INT
); """
cursor_obj.execute(table)
# inserting data into geek table
connection_obj.execute(
"""INSERT INTO GEEK (Email,Name,Score) VALUES ("geekk1@gmail.com","Geek1",25)""")
connection_obj.execute(
"""INSERT INTO GEEK (Email,Name,Score) VALUES ("geekk2@gmail.com","Geek2",15)""")
connection_obj.execute(
"""INSERT INTO GEEK (Email,Name,Score) VALUES ("geekk3@gmail.com","Geek3",36)""")
connection_obj.execute(
"""INSERT INTO GEEK (Email,Name,Score) VALUES ("geekk4@gmail.com","Geek4",27)""")
connection_obj.execute(
"""INSERT INTO GEEK (Email,Name,Score) VALUES ("geekk5@gmail.com","Geek5",40)""")
connection_obj.execute(
"""INSERT INTO GEEK (Email,Name,Score) VALUES ("geekk6@gmail.com","Geek6",14)""")
connection_obj.execute(
"""INSERT INTO GEEK (Email,Name,Score) VALUES ("geekk7@gmail.com","Geek7",10)""")
connection_obj.commit()
# Close the connection
connection_obj.close()