python数据库execute返回值_Python MySQLdb execute返回

At this point your query has been executed and you need to get the

results. You have two options:

r=db.store_result()

...or... r=db.use_result() Both methods return a result object. What's the difference? store_result() returns the entire result set to

the client immediately. If your result set is really large, this could

be a problem. One way around this is to add a LIMIT clause to your

query, to limit the number of rows returned. The other is to use

use_result(), which keeps the result set in the server and sends it

row-by-row when you fetch. This does, however, tie up server

resources, and it ties up the connection: You cannot do any more

queries until you have fetched all the rows. Generally I recommend

using store_result() unless your result set is really huge and you

can't use LIMIT for some reason.