What is the query operation of the database executed by python?

Today, I would like to share with you the relevant knowledge of what the query operation of the database implemented by python is. The content is detailed and the logic is clear. I believe most people still know too much about this knowledge, so share this article for your reference. I hope you can get something after reading this article. Let's take a look.

1. Fetchone this method gets the next query result set. The result set is an object.

2. Fetchall receives all the returned result rows.

3. Rowcount this is a read-only property and returns the number of rows affected after the execution of the execute method.

Example

From pymysql import * def main (): # create a Connection connection conn = connect (host='localhost',port=3306,user='root',password='mysql',database='jing_dong',charset='utf8') # get the Cursor object cs1 = conn.cursor () # execute the select statement And return the number of affected rows: query a piece of data count = cs1.execute ('select id,name from goods where id > = 4') # print the number of affected rows print ("query% d pieces of data:"% count) for i in range (count): # get the result of the query result = cs1.fetchone () # print the result of the query print (result) # tuple (1 'Zhang San', 20, 'male') # get the results of the query # close the Cursor object cs1.close () conn.close () if _ _ name__ = ='_ _ main__': main () these are all the contents of the article "what is the query operation of the python execution database" Thank you for reading! I believe you will gain a lot after reading this article. The editor will update different knowledge for you every day. If you want to learn more knowledge, please pay attention to the industry information channel.