Shulou(Shulou.com)05/31 Report--

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.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.