[Tutor] SQL headache with column

[Bernard Lebel]

Hello,

Not sure if it's a Python thing, but...

When sending command to the MySQL server by command line, I can use
SHOW COLUMNS FROM <tablename>, the list of all columns with a bunch of
properties is printed.

However, when I run the same command from Python and I store the
result, the result is an integer that only tell the number of columns.
I would like to get the column names!


def getTableColumns( sTableName ):
	
	""" Lists and returns the list of columns from a given table. """
	
	oConnection = connect2db()
	oCursor = oConnection.cursor()
	
	oResult = oCursor.execute( "SHOW COLUMNS FROM " + sTableName + "" )
	print str( oResult )
	
	oCursor.close()
	oConnection.close()



Prints "33" (I have 33 columns)


Thanks
Bernard