Python’s popular MySQL driver (MySQLdb) offers multiple types of cursors for issuing commands to the database server. You’ll often see beginners’ database-connecting python code sprinkled with :
for row in cursor.fetchall():
first_name, last_name, zipcode = row, row, row
Here’s the better alternative:
How are join results handled if two column names are the same? Well they are accessible by “table.column” key rather than just “column”. Pretty slick stuff.