Note: This site is currently "Under construction". I'm migrating to a new version of my site building software. Lots of things are in a state of disrepair as a result (for example, footnote links aren't working). It's all part of the process of building in public. Most things should still be readable though.

Loop Through MySQL Results

TODO: Make this a full example:

Code

cursor.execute("SELECT * FROM some_table")
for row in cursor:
    print(row)

See more here:

https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlcursor-fetchone.html