Re: LEFT JOIN give different result in PhpMyAdmin and Python code

[Grasp Skills]

You will need to have Python (including the MySQLdb and sys modules) and MySQL installed. We will also use the same database table (address) from a previous post, Inserting Data into MySQL with Perl.

Fetch a single line:

# fetch a single row using fetchone() method.
row = cursor.fetchone ()

Fetch multiple rows:

# fetch all of the rows from the query
data = cursor.fetchall ()