How to execute database query operation in python

This article will explain in detail how to query the database in python. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

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 () on how to perform database query operations in python, this article ends here Hope that the above content can be helpful to you, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.