title: python: MYSQLdb. how to get columns name without executing select * in a big table?
body: <p>I want to get the column names of a table, but there a over million data in it.
  So I cannot use:</p>
  
  <pre><code>cursor.execute("SELECT * FROM table_name")
  print cursor.description
  </code></pre>
  
  <p>And in sqlite3, I do it this way</p>
  
  <pre><code>crs.execute("PRAGMA table_info(%s)" %(tablename[0]))
  for info in crs:
      print info
  </code></pre>
  
  <p>But this is not working in python mysqldb. Any one know how to do that?</p>