Shulou(Shulou.com)06/01 Report--

Editor to share with you Python operation MySQL how to get a single table field name and information, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

The method of getting the field name and information of a single table

Import MySQLdb as mdbimport sys# gets the link object of the database con = mdb.connect ('localhost',' root', 'root',' test') with con:# gets the common query cursorcur = con.cursor () cur.execute ("SELECT * FROM Writers") rows = cur.fetchall () # gets the description information of the connection object desc = cur.descriptionprint 'cur.description:',desc# print header Is the field name print "% s% 3s"% (desc [0] [0], desc [1] [0]) for row in rows:# print result print "% 2s% 3s"% row is all the content of the article "how to get the field name and information of a single table by Python operation MySQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow 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.