Retrieve The Structure Of A MySQL Table From A Python Program

# import the mysql client library
import pymysql

# Connection creation
serverIP            = "127.0.0.1"
serverUser          = "test"  
serverUserPwd       = "phraseone"       
characterSet        = "utf8mb4"
cursorType          = pymysql.cursors.DictCursor

mySQLConnection   = pymysql.connect(host=serverIP,
                                    user=serverUser,
                                    password=serverUserPwd,
                                    charset=characterSet,
                                    cursorclass=cursorType)

try:
    # Obtain a cursor object
    cursorObject    =

mySQLConnection.cursor()                                  

    # Execute DESCRIBE statement
    cursorObject.execute("DESCRIBE test.UserList")

    # Fetch and print the meta-data of the table
    indexList = cursorObject.fetchall()

    print(indexList)

except Exception as e:
    print("Exception occured:{}".format(e))

finally:
    mySQLConnection.close()